Returning values from a table formatted as rows rather than columns Announcing the arrival of...
Why do people think Winterfell crypts is the safest place for women, children & old people?
Is my guitar’s action too high?
Does Prince Arnaud cause someone holding the Princess to lose?
What is the definining line between a helicopter and a drone a person can ride in?
"Destructive force" carried by a B-52?
Suing a Police Officer Instead of the Police Department
How is an IPA symbol that lacks a name (e.g. ɲ) called?
Is Bran literally the world's memory?
Etymology of 見舞い
Why aren't road bike wheels tiny?
/bin/ls sorts differently than just ls
Why does BitLocker not use RSA?
Why do C and C++ allow the expression (int) + 4*5?
Will I be more secure with my own router behind my ISP's router?
How to produce a PS1 prompt in bash or ksh93 similar to tcsh
Why is one lightbulb in a string illuminated?
What could prevent concentrated local exploration?
Are Flameskulls resistant to magical piercing damage?
Is the Mordenkainen's Sword spell underpowered?
Does using the Inspiration rules for character defects encourage My Guy Syndrome?
Why does my GNOME settings mention "Moto C Plus"?
Recursive calls to a function - why is the address of the parameter passed to it lowering with each call?
Meaning of "Not holding on that level of emuna/bitachon"
Unix AIX passing variable and arguments to expect and spawn
Returning values from a table formatted as rows rather than columns
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)In Excel I need to find data matches between two arrays - one horizontal and one verticalCopying columns in Excel from sheet1 to sheet2 without having to cut and pasteHow to omit returning the rows for “false” valuesExcel 2013 match values in two workbooks and merge one columnHow to reflect sheet1's those rows only which contains positive values, into sheet2?More complicated version of 990125 (Excel: take horizontal data from table, organize vertically in a different sheet, ignoring blanks)Index/Match - in table containing multiple similar valuesExcel using filling columns from rowsExcel - find values searching columns first, than rows from found columnExcel formula that arranges rows in a column based on the rows arrangement from another column
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
How do you return multiples values from a table that is based on rows rather than columns? I am getting no values returned from this formula. I am trying to search row c25 on Sheet 1 for all instances of "c" then return all instances from row c3 sheet 1 into row 9 on sheet 2.
=IFERROR(INDEX(Sheet2!9D9:CG9,SMALL(IF(B9=SHEET1!C25:CG25,COLUMN(SHEET1!C25:CG25)-MIN(COLUMN(SHEET1!C25:CG25))+1,""),COLUMN()-2)),"NADA")
microsoft-excel
New contributor
add a comment |
How do you return multiples values from a table that is based on rows rather than columns? I am getting no values returned from this formula. I am trying to search row c25 on Sheet 1 for all instances of "c" then return all instances from row c3 sheet 1 into row 9 on sheet 2.
=IFERROR(INDEX(Sheet2!9D9:CG9,SMALL(IF(B9=SHEET1!C25:CG25,COLUMN(SHEET1!C25:CG25)-MIN(COLUMN(SHEET1!C25:CG25))+1,""),COLUMN()-2)),"NADA")
microsoft-excel
New contributor
A mockup or sample of your data would help us better help you.
– music2myear
3 hours ago
add a comment |
How do you return multiples values from a table that is based on rows rather than columns? I am getting no values returned from this formula. I am trying to search row c25 on Sheet 1 for all instances of "c" then return all instances from row c3 sheet 1 into row 9 on sheet 2.
=IFERROR(INDEX(Sheet2!9D9:CG9,SMALL(IF(B9=SHEET1!C25:CG25,COLUMN(SHEET1!C25:CG25)-MIN(COLUMN(SHEET1!C25:CG25))+1,""),COLUMN()-2)),"NADA")
microsoft-excel
New contributor
How do you return multiples values from a table that is based on rows rather than columns? I am getting no values returned from this formula. I am trying to search row c25 on Sheet 1 for all instances of "c" then return all instances from row c3 sheet 1 into row 9 on sheet 2.
=IFERROR(INDEX(Sheet2!9D9:CG9,SMALL(IF(B9=SHEET1!C25:CG25,COLUMN(SHEET1!C25:CG25)-MIN(COLUMN(SHEET1!C25:CG25))+1,""),COLUMN()-2)),"NADA")
microsoft-excel
microsoft-excel
New contributor
New contributor
edited 6 hours ago
cybernetic.nomad
2,822617
2,822617
New contributor
asked 6 hours ago
crbcrb
1
1
New contributor
New contributor
A mockup or sample of your data would help us better help you.
– music2myear
3 hours ago
add a comment |
A mockup or sample of your data would help us better help you.
– music2myear
3 hours ago
A mockup or sample of your data would help us better help you.
– music2myear
3 hours ago
A mockup or sample of your data would help us better help you.
– music2myear
3 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
crb is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1428375%2freturning-values-from-a-table-formatted-as-rows-rather-than-columns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
crb is a new contributor. Be nice, and check out our Code of Conduct.
crb is a new contributor. Be nice, and check out our Code of Conduct.
crb is a new contributor. Be nice, and check out our Code of Conduct.
crb is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1428375%2freturning-values-from-a-table-formatted-as-rows-rather-than-columns%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
A mockup or sample of your data would help us better help you.
– music2myear
3 hours ago