I am trying to obtain formula to increment cell by 11 rows for Google Sheets
Here is what I am doing:
=IF('unique stock'!C11<=0,'unique stock'!C11,"")
and this goes on...
=IF('unique stock'!C22<=0,'unique stock'!C22,"")
=IF('unique stock'!C33<=0,'unique stock'!C33,"")
=IF('unique stock'!C44<=0,'unique stock'!C44,"")
Here, I am incrementing each cell by 11 rows manually. Please tell me if there is any way to increment rows by 11 dynamically for each cell.
google-sheets formulas google-sheets-arrayformula
edited Jan 29 at 15:45
user0
10k71533
migrated from superuser.com Jan 29 at 7:11
This question came from our site for computer enthusiasts and power users.
add a comment |
Here is what I am doing:
=IF('unique stock'!C11<=0,'unique stock'!C11,"")
and this goes on...
=IF('unique stock'!C22<=0,'unique stock'!C22,"")
=IF('unique stock'!C33<=0,'unique stock'!C33,"")
=IF('unique stock'!C44<=0,'unique stock'!C44,"")
Here, I am incrementing each cell by 11 rows manually. Please tell me if there is any way to increment rows by 11 dynamically for each cell.
google-sheets formulas google-sheets-arrayformula
edited Jan 29 at 15:45
user0
10k71533
migrated from superuser.com Jan 29 at 7:11
This question came from our site for computer enthusiasts and power users.
you need to use ArrayFormula
– user0
Jan 29 at 15:43
add a comment |
Here is what I am doing:
=IF('unique stock'!C11<=0,'unique stock'!C11,"")
and this goes on...
=IF('unique stock'!C22<=0,'unique stock'!C22,"")
=IF('unique stock'!C33<=0,'unique stock'!C33,"")
=IF('unique stock'!C44<=0,'unique stock'!C44,"")
Here, I am incrementing each cell by 11 rows manually. Please tell me if there is any way to increment rows by 11 dynamically for each cell.
google-sheets formulas google-sheets-arrayformula
edited Jan 29 at 15:45
user0
10k71533
Here is what I am doing:
=IF('unique stock'!C11<=0,'unique stock'!C11,"")
and this goes on...
=IF('unique stock'!C22<=0,'unique stock'!C22,"")
=IF('unique stock'!C33<=0,'unique stock'!C33,"")
=IF('unique stock'!C44<=0,'unique stock'!C44,"")
Here, I am incrementing each cell by 11 rows manually. Please tell me if there is any way to increment rows by 11 dynamically for each cell.
google-sheets formulas google-sheets-arrayformula
google-sheets formulas google-sheets-arrayformula
edited Jan 29 at 15:45
user0
10k71533
edited Jan 29 at 15:45
user0
10k71533
edited Jan 29 at 15:45
user0
10k71533
edited Jan 29 at 15:45
user0
10k71533
edited Jan 29 at 15:45
user0
10k71533
10k71533
asked Jan 25 at 12:37
FATHIMA
migrated from superuser.com Jan 29 at 7:11
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Jan 29 at 7:11
This question came from our site for computer enthusiasts and power users.
you need to use ArrayFormula
– user0
Jan 29 at 15:43
add a comment |
you need to use ArrayFormula
– user0
Jan 29 at 15:43
you need to use ArrayFormula
– user0
Jan 29 at 15:43
you need to use ArrayFormula
– user0
Jan 29 at 15:43
add a comment |
2 Answers
2
active
oldest
votes
In excel you could use the following for a cell reference that would start at C11 and Jump by 11 for each row copied down:
INDEX(C:C,ROW(A1)*11)
You just need to substitute it into your equation.
=IF(INDEX('unique stock'!C:C,ROW(A1)*11)<=0,INDEX('unique stock'!C:C,ROW(A1)*11),"")
I am not sure if Google Sheets performs the function in the same manner as excel.
edited Jan 29 at 12:47
serenesat
8,926102242
answered Jan 25 at 12:53
Forward EdForward Ed
1112
add a comment |
=ARRAYFORMULA(IF(LEN('unique stock'!C11:C44),
IF('unique stock'!C11:C44<=0,
'unique stock'!C11:C44, ), ))
answered Jan 29 at 15:43
user0user0
10k71533
add a comment |
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "34"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f124753%2fi-am-trying-to-obtain-formula-to-increment-cell-by-11-rows-for-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
In excel you could use the following for a cell reference that would start at C11 and Jump by 11 for each row copied down:
INDEX(C:C,ROW(A1)*11)
You just need to substitute it into your equation.
=IF(INDEX('unique stock'!C:C,ROW(A1)*11)<=0,INDEX('unique stock'!C:C,ROW(A1)*11),"")
I am not sure if Google Sheets performs the function in the same manner as excel.
edited Jan 29 at 12:47
serenesat
8,926102242
answered Jan 25 at 12:53
Forward EdForward Ed
1112
add a comment |
In excel you could use the following for a cell reference that would start at C11 and Jump by 11 for each row copied down:
INDEX(C:C,ROW(A1)*11)
You just need to substitute it into your equation.
=IF(INDEX('unique stock'!C:C,ROW(A1)*11)<=0,INDEX('unique stock'!C:C,ROW(A1)*11),"")
I am not sure if Google Sheets performs the function in the same manner as excel.
edited Jan 29 at 12:47
serenesat
8,926102242
answered Jan 25 at 12:53
Forward EdForward Ed
1112
add a comment |
In excel you could use the following for a cell reference that would start at C11 and Jump by 11 for each row copied down:
INDEX(C:C,ROW(A1)*11)
You just need to substitute it into your equation.
=IF(INDEX('unique stock'!C:C,ROW(A1)*11)<=0,INDEX('unique stock'!C:C,ROW(A1)*11),"")
I am not sure if Google Sheets performs the function in the same manner as excel.
edited Jan 29 at 12:47
serenesat
8,926102242
answered Jan 25 at 12:53
Forward EdForward Ed
1112
In excel you could use the following for a cell reference that would start at C11 and Jump by 11 for each row copied down:
INDEX(C:C,ROW(A1)*11)
You just need to substitute it into your equation.
=IF(INDEX('unique stock'!C:C,ROW(A1)*11)<=0,INDEX('unique stock'!C:C,ROW(A1)*11),"")
I am not sure if Google Sheets performs the function in the same manner as excel.
edited Jan 29 at 12:47
serenesat
8,926102242
answered Jan 25 at 12:53
Forward EdForward Ed
1112
edited Jan 29 at 12:47
serenesat
8,926102242
edited Jan 29 at 12:47
serenesat
8,926102242
edited Jan 29 at 12:47
serenesat
8,926102242
8,926102242
answered Jan 25 at 12:53
Forward EdForward Ed
1112
answered Jan 25 at 12:53
Forward EdForward Ed
1112
answered Jan 25 at 12:53
Forward EdForward Ed
1112
1112
add a comment |
add a comment |
=ARRAYFORMULA(IF(LEN('unique stock'!C11:C44),
IF('unique stock'!C11:C44<=0,
'unique stock'!C11:C44, ), ))
answered Jan 29 at 15:43
user0user0
10k71533
add a comment |
=ARRAYFORMULA(IF(LEN('unique stock'!C11:C44),
IF('unique stock'!C11:C44<=0,
'unique stock'!C11:C44, ), ))
answered Jan 29 at 15:43
user0user0
10k71533
add a comment |
=ARRAYFORMULA(IF(LEN('unique stock'!C11:C44),
IF('unique stock'!C11:C44<=0,
'unique stock'!C11:C44, ), ))
answered Jan 29 at 15:43
user0user0
10k71533
=ARRAYFORMULA(IF(LEN('unique stock'!C11:C44),
IF('unique stock'!C11:C44<=0,
'unique stock'!C11:C44, ), ))
answered Jan 29 at 15:43
user0user0
10k71533
answered Jan 29 at 15:43
user0user0
10k71533
answered Jan 29 at 15:43
user0user0
10k71533
answered Jan 29 at 15:43
user0user0
10k71533
10k71533
add a comment |
add a comment |
Thanks for contributing an answer to Web Applications Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f124753%2fi-am-trying-to-obtain-formula-to-increment-cell-by-11-rows-for-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
you need to use ArrayFormula
– user0
Jan 29 at 15:43