(Excel) If a value in a column matches given value return entire row
In sheet 1 I have data from every single NBA game in a season. Column D contains the teams name that played the game.
In sheet 2 I want to input a teams name and get all rows (from sheet 1) that match the team I entered.
How would I go about doing this? Thanks in advance.
microsoft-excel
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
|
show 1 more comment
In sheet 1 I have data from every single NBA game in a season. Column D contains the teams name that played the game.
In sheet 2 I want to input a teams name and get all rows (from sheet 1) that match the team I entered.
How would I go about doing this? Thanks in advance.
microsoft-excel
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
1
Step 1: Do some research.
– Scott
Feb 5 at 3:11
To elaborate on the comment from @Scott look into Index & Match functions.
– angelofdev
Feb 5 at 3:42
Better share some sample data, since you wrote Team Name are in Col D (what I guess is the middle Cell value) if data Range isA2:F10like.
– Rajesh S
Feb 5 at 6:08
Exactly what is in col D? Both teams or a single team? If both, how are they separated? How about a screenshot?
– fixer1234
Feb 5 at 6:15
Please provide a sample about your problem first, THANKS.
– Lee
Feb 5 at 7:26
|
show 1 more comment
In sheet 1 I have data from every single NBA game in a season. Column D contains the teams name that played the game.
In sheet 2 I want to input a teams name and get all rows (from sheet 1) that match the team I entered.
How would I go about doing this? Thanks in advance.
microsoft-excel
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
In sheet 1 I have data from every single NBA game in a season. Column D contains the teams name that played the game.
In sheet 2 I want to input a teams name and get all rows (from sheet 1) that match the team I entered.
How would I go about doing this? Thanks in advance.
microsoft-excel
microsoft-excel
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
asked Feb 5 at 2:58
Drew BakerDrew Baker
6
6
1
Step 1: Do some research.
– Scott
Feb 5 at 3:11
To elaborate on the comment from @Scott look into Index & Match functions.
– angelofdev
Feb 5 at 3:42
Better share some sample data, since you wrote Team Name are in Col D (what I guess is the middle Cell value) if data Range isA2:F10like.
– Rajesh S
Feb 5 at 6:08
Exactly what is in col D? Both teams or a single team? If both, how are they separated? How about a screenshot?
– fixer1234
Feb 5 at 6:15
Please provide a sample about your problem first, THANKS.
– Lee
Feb 5 at 7:26
|
show 1 more comment
1
Step 1: Do some research.
– Scott
Feb 5 at 3:11
To elaborate on the comment from @Scott look into Index & Match functions.
– angelofdev
Feb 5 at 3:42
Better share some sample data, since you wrote Team Name are in Col D (what I guess is the middle Cell value) if data Range isA2:F10like.
– Rajesh S
Feb 5 at 6:08
Exactly what is in col D? Both teams or a single team? If both, how are they separated? How about a screenshot?
– fixer1234
Feb 5 at 6:15
Please provide a sample about your problem first, THANKS.
– Lee
Feb 5 at 7:26
1
1
Step 1: Do some research.
– Scott
Feb 5 at 3:11
Step 1: Do some research.
– Scott
Feb 5 at 3:11
To elaborate on the comment from @Scott look into Index & Match functions.
– angelofdev
Feb 5 at 3:42
To elaborate on the comment from @Scott look into Index & Match functions.
– angelofdev
Feb 5 at 3:42
Better share some sample data, since you wrote Team Name are in Col D (what I guess is the middle Cell value) if data Range is
A2:F10 like.– Rajesh S
Feb 5 at 6:08
Better share some sample data, since you wrote Team Name are in Col D (what I guess is the middle Cell value) if data Range is
A2:F10 like.– Rajesh S
Feb 5 at 6:08
Exactly what is in col D? Both teams or a single team? If both, how are they separated? How about a screenshot?
– fixer1234
Feb 5 at 6:15
Exactly what is in col D? Both teams or a single team? If both, how are they separated? How about a screenshot?
– fixer1234
Feb 5 at 6:15
Please provide a sample about your problem first, THANKS.
– Lee
Feb 5 at 7:26
Please provide a sample about your problem first, THANKS.
– Lee
Feb 5 at 7:26
|
show 1 more comment
1 Answer
1
active
oldest
votes
Entire rows, that can be in any number, cann't be extracted through a formula.
Using Countif() you will get how many times that team is appearing in the first sheet, then it will be a different task to extract all rows from first sheet and put each column at proper place in Sheet B.
What you are saying doesn't even need Sheet B.
In the first Sheet itself, you select entire top heading, and click on Menu - Data - Filter.
That will put a filter on you data.
Then, the column in which your team name is there, you click on filter (the funnel icon at the end of the header name) and put a team's name and press enter.
All the rows of only that team will show up, and all rows in which that team was not there will be hidden.
answered Feb 6 at 16:24
VSRawatVSRawat
15512
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
});
}
});
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%2f1402084%2fexcel-if-a-value-in-a-column-matches-given-value-return-entire-row%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
Entire rows, that can be in any number, cann't be extracted through a formula.
Using Countif() you will get how many times that team is appearing in the first sheet, then it will be a different task to extract all rows from first sheet and put each column at proper place in Sheet B.
What you are saying doesn't even need Sheet B.
In the first Sheet itself, you select entire top heading, and click on Menu - Data - Filter.
That will put a filter on you data.
Then, the column in which your team name is there, you click on filter (the funnel icon at the end of the header name) and put a team's name and press enter.
All the rows of only that team will show up, and all rows in which that team was not there will be hidden.
answered Feb 6 at 16:24
VSRawatVSRawat
15512
add a comment |
Entire rows, that can be in any number, cann't be extracted through a formula.
Using Countif() you will get how many times that team is appearing in the first sheet, then it will be a different task to extract all rows from first sheet and put each column at proper place in Sheet B.
What you are saying doesn't even need Sheet B.
In the first Sheet itself, you select entire top heading, and click on Menu - Data - Filter.
That will put a filter on you data.
Then, the column in which your team name is there, you click on filter (the funnel icon at the end of the header name) and put a team's name and press enter.
All the rows of only that team will show up, and all rows in which that team was not there will be hidden.
answered Feb 6 at 16:24
VSRawatVSRawat
15512
add a comment |
Entire rows, that can be in any number, cann't be extracted through a formula.
Using Countif() you will get how many times that team is appearing in the first sheet, then it will be a different task to extract all rows from first sheet and put each column at proper place in Sheet B.
What you are saying doesn't even need Sheet B.
In the first Sheet itself, you select entire top heading, and click on Menu - Data - Filter.
That will put a filter on you data.
Then, the column in which your team name is there, you click on filter (the funnel icon at the end of the header name) and put a team's name and press enter.
All the rows of only that team will show up, and all rows in which that team was not there will be hidden.
answered Feb 6 at 16:24
VSRawatVSRawat
15512
Entire rows, that can be in any number, cann't be extracted through a formula.
Using Countif() you will get how many times that team is appearing in the first sheet, then it will be a different task to extract all rows from first sheet and put each column at proper place in Sheet B.
What you are saying doesn't even need Sheet B.
In the first Sheet itself, you select entire top heading, and click on Menu - Data - Filter.
That will put a filter on you data.
Then, the column in which your team name is there, you click on filter (the funnel icon at the end of the header name) and put a team's name and press enter.
All the rows of only that team will show up, and all rows in which that team was not there will be hidden.
answered Feb 6 at 16:24
VSRawatVSRawat
15512
answered Feb 6 at 16:24
VSRawatVSRawat
15512
answered Feb 6 at 16:24
VSRawatVSRawat
15512
answered Feb 6 at 16:24
VSRawatVSRawat
15512
15512
add a comment |
add a comment |
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%2f1402084%2fexcel-if-a-value-in-a-column-matches-given-value-return-entire-row%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
1
Step 1: Do some research.
– Scott
Feb 5 at 3:11
To elaborate on the comment from @Scott look into Index & Match functions.
– angelofdev
Feb 5 at 3:42
Better share some sample data, since you wrote Team Name are in Col D (what I guess is the middle Cell value) if data Range is
A2:F10like.– Rajesh S
Feb 5 at 6:08
Exactly what is in col D? Both teams or a single team? If both, how are they separated? How about a screenshot?
– fixer1234
Feb 5 at 6:15
Please provide a sample about your problem first, THANKS.
– Lee
Feb 5 at 7:26