Excel formula that arranges rows in a column based on the rows arrangement from another column ...
When communicating altitude with a '9' in it, should it be pronounced "nine hundred" or "niner hundred"?
How do I automatically answer y in bash script?
Can a zero nonce be safely used with AES-GCM if the key is random and never used again?
Can I throw a longsword at someone?
Replacing HDD with SSD; what about non-APFS/APFS?
Working around an AWS network ACL rule limit
Can a monk deflect thrown melee weapons?
How are presidential pardons supposed to be used?
Stars Make Stars
What computer would be fastest for Mathematica Home Edition?
How can I make names more distinctive without making them longer?
Should you tell Jews they are breaking a commandment?
Fishing simulator
How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time
Why is there no army of Iron-Mans in the MCU?
Unexpected result with right shift after bitwise negation
Problem when applying foreach loop
I'm having difficulty getting my players to do stuff in a sandbox campaign
The following signatures were invalid: EXPKEYSIG 1397BC53640DB551
Classification of bundles, Postnikov towers, obstruction theory, local coefficients
What to do with post with dry rot?
What do you call the holes in a flute?
What is the largest species of polychaete?
Was credit for the black hole image misattributed?
Excel formula that arranges rows in a column based on the rows arrangement from another column
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Excel - Possible to create a sorted view of a column in one sheet on another sheet?How to Split one column in Excel into multiple columns of 55 rowsExcel 2013 match values in two workbooks and merge one columnRetrieving data from one sheet to another excel sheet having same key valueHow to delete rows in excel based on column valuesExcel using filling columns from rowsCombine column data of two sheets based on formulaAutofill a column in one sheet with the values from a column in anotherHow do I keep an Excel formula from changing the sheet it refers to?Map/Copy values from one sheet to another in excel if they match on column header
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have 2 sheet in excel 2010s: In the 1st Sheet I have all the data and a 2nd sheet where based on the ID's entered(TP) on column A-Sheet2 the formula returns rows from Sheet1.
It looks like this:
Formula used : =IF(COUNTIF(Sheet2!$A:$A,Sheet1!$E1),IF(ISBLANK(Sheet1!E1),"",Sheet1!E1),"")
As it can be seen, in column A from Sheet2 the ID's entered are in a specific order (they are copied from another excel file). Is there a formula that arranges the findings from Sheet2 (column F,G,H) in the same line with Id's from column A-Sheet2?
In the end it should look like:
microsoft-excel
edited yesterday
mature
261211
asked yesterday
othe Bogdanothe Bogdan
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have 2 sheet in excel 2010s: In the 1st Sheet I have all the data and a 2nd sheet where based on the ID's entered(TP) on column A-Sheet2 the formula returns rows from Sheet1.
It looks like this:
Formula used : =IF(COUNTIF(Sheet2!$A:$A,Sheet1!$E1),IF(ISBLANK(Sheet1!E1),"",Sheet1!E1),"")
As it can be seen, in column A from Sheet2 the ID's entered are in a specific order (they are copied from another excel file). Is there a formula that arranges the findings from Sheet2 (column F,G,H) in the same line with Id's from column A-Sheet2?
In the end it should look like:
microsoft-excel
edited yesterday
mature
261211
asked yesterday
othe Bogdanothe Bogdan
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have 2 sheet in excel 2010s: In the 1st Sheet I have all the data and a 2nd sheet where based on the ID's entered(TP) on column A-Sheet2 the formula returns rows from Sheet1.
It looks like this:
Formula used : =IF(COUNTIF(Sheet2!$A:$A,Sheet1!$E1),IF(ISBLANK(Sheet1!E1),"",Sheet1!E1),"")
As it can be seen, in column A from Sheet2 the ID's entered are in a specific order (they are copied from another excel file). Is there a formula that arranges the findings from Sheet2 (column F,G,H) in the same line with Id's from column A-Sheet2?
In the end it should look like:
microsoft-excel
edited yesterday
mature
261211
asked yesterday
othe Bogdanothe Bogdan
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have 2 sheet in excel 2010s: In the 1st Sheet I have all the data and a 2nd sheet where based on the ID's entered(TP) on column A-Sheet2 the formula returns rows from Sheet1.
It looks like this:
Formula used : =IF(COUNTIF(Sheet2!$A:$A,Sheet1!$E1),IF(ISBLANK(Sheet1!E1),"",Sheet1!E1),"")
As it can be seen, in column A from Sheet2 the ID's entered are in a specific order (they are copied from another excel file). Is there a formula that arranges the findings from Sheet2 (column F,G,H) in the same line with Id's from column A-Sheet2?
In the end it should look like:
microsoft-excel
microsoft-excel
edited yesterday
mature
261211
asked yesterday
othe Bogdanothe Bogdan
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
mature
261211
asked yesterday
othe Bogdanothe Bogdan
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
mature
261211
edited yesterday
mature
261211
edited yesterday
mature
261211
261211
asked yesterday
othe Bogdanothe Bogdan
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
othe Bogdanothe Bogdan
1
asked yesterday
othe Bogdanothe Bogdan
1
1
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
othe Bogdan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Yes, try this index match match formula:
=IF($A4="","-",INDEX(Sheet1!$A$1:$G$11,MATCH(Sheet2!$A4,Sheet1!$E$1:$E$11,0),MATCH(Sheet2!E$1,Sheet1!$A$1:$G$1,0)))
Paste that into sheet2, cell E5, then copy that cell to E5:H12.
The function focuses on the table in sheet1. Change the coordinates $A$1:$G$11 if your sheet1 table is bigger. The function matches the sheet2 column A value to a row in column E in the table, and then matches the sheet2 row 1 heading to a column in row 1 of the table, "indexing" a single result. The formula is copyable to any row or column on sheet2. Note that column headings must be spelled the same way as the sheet1 column headings.
answered yesterday
DavidDavid
42425
add a comment |
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
});
}
});
othe Bogdan 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%2f1425006%2fexcel-formula-that-arranges-rows-in-a-column-based-on-the-rows-arrangement-from%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Yes, try this index match match formula:
=IF($A4="","-",INDEX(Sheet1!$A$1:$G$11,MATCH(Sheet2!$A4,Sheet1!$E$1:$E$11,0),MATCH(Sheet2!E$1,Sheet1!$A$1:$G$1,0)))
Paste that into sheet2, cell E5, then copy that cell to E5:H12.
The function focuses on the table in sheet1. Change the coordinates $A$1:$G$11 if your sheet1 table is bigger. The function matches the sheet2 column A value to a row in column E in the table, and then matches the sheet2 row 1 heading to a column in row 1 of the table, "indexing" a single result. The formula is copyable to any row or column on sheet2. Note that column headings must be spelled the same way as the sheet1 column headings.
answered yesterday
DavidDavid
42425
add a comment |
Yes, try this index match match formula:
=IF($A4="","-",INDEX(Sheet1!$A$1:$G$11,MATCH(Sheet2!$A4,Sheet1!$E$1:$E$11,0),MATCH(Sheet2!E$1,Sheet1!$A$1:$G$1,0)))
Paste that into sheet2, cell E5, then copy that cell to E5:H12.
The function focuses on the table in sheet1. Change the coordinates $A$1:$G$11 if your sheet1 table is bigger. The function matches the sheet2 column A value to a row in column E in the table, and then matches the sheet2 row 1 heading to a column in row 1 of the table, "indexing" a single result. The formula is copyable to any row or column on sheet2. Note that column headings must be spelled the same way as the sheet1 column headings.
answered yesterday
DavidDavid
42425
add a comment |
Yes, try this index match match formula:
=IF($A4="","-",INDEX(Sheet1!$A$1:$G$11,MATCH(Sheet2!$A4,Sheet1!$E$1:$E$11,0),MATCH(Sheet2!E$1,Sheet1!$A$1:$G$1,0)))
Paste that into sheet2, cell E5, then copy that cell to E5:H12.
The function focuses on the table in sheet1. Change the coordinates $A$1:$G$11 if your sheet1 table is bigger. The function matches the sheet2 column A value to a row in column E in the table, and then matches the sheet2 row 1 heading to a column in row 1 of the table, "indexing" a single result. The formula is copyable to any row or column on sheet2. Note that column headings must be spelled the same way as the sheet1 column headings.
answered yesterday
DavidDavid
42425
Yes, try this index match match formula:
=IF($A4="","-",INDEX(Sheet1!$A$1:$G$11,MATCH(Sheet2!$A4,Sheet1!$E$1:$E$11,0),MATCH(Sheet2!E$1,Sheet1!$A$1:$G$1,0)))
Paste that into sheet2, cell E5, then copy that cell to E5:H12.
The function focuses on the table in sheet1. Change the coordinates $A$1:$G$11 if your sheet1 table is bigger. The function matches the sheet2 column A value to a row in column E in the table, and then matches the sheet2 row 1 heading to a column in row 1 of the table, "indexing" a single result. The formula is copyable to any row or column on sheet2. Note that column headings must be spelled the same way as the sheet1 column headings.
answered yesterday
DavidDavid
42425
answered yesterday
DavidDavid
42425
answered yesterday
DavidDavid
42425
answered yesterday
DavidDavid
42425
42425
add a comment |
add a comment |
othe Bogdan is a new contributor. Be nice, and check out our Code of Conduct.
othe Bogdan is a new contributor. Be nice, and check out our Code of Conduct.
othe Bogdan is a new contributor. Be nice, and check out our Code of Conduct.
othe Bogdan 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%2f1425006%2fexcel-formula-that-arranges-rows-in-a-column-based-on-the-rows-arrangement-from%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
