Filter Excel table matching two columns values
up vote
0
down vote
favorite
I have an excel table I want to filter only the rows in which the value of the numeric column "customLabel" matches with one of the rows of another column in another google sheet.
Can I use the advanced filter function or should I write a custom function?
Thanks
microsoft-excel csv
asked Nov 8 at 18:14
Raziel
1
add a comment |
up vote
0
down vote
favorite
I have an excel table I want to filter only the rows in which the value of the numeric column "customLabel" matches with one of the rows of another column in another google sheet.
Can I use the advanced filter function or should I write a custom function?
Thanks
microsoft-excel csv
asked Nov 8 at 18:14
Raziel
1
2
Your question is likely to get downvoted unless you edit your question to show us sample data, expected outcome and what you've tried so far.
– cybernetic.nomad
Nov 8 at 18:16
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have an excel table I want to filter only the rows in which the value of the numeric column "customLabel" matches with one of the rows of another column in another google sheet.
Can I use the advanced filter function or should I write a custom function?
Thanks
microsoft-excel csv
asked Nov 8 at 18:14
Raziel
1
I have an excel table I want to filter only the rows in which the value of the numeric column "customLabel" matches with one of the rows of another column in another google sheet.
Can I use the advanced filter function or should I write a custom function?
Thanks
microsoft-excel csv
microsoft-excel csv
asked Nov 8 at 18:14
Raziel
1
asked Nov 8 at 18:14
Raziel
1
asked Nov 8 at 18:14
Raziel
1
asked Nov 8 at 18:14
Raziel
1
asked Nov 8 at 18:14
Raziel
1
1
2
Your question is likely to get downvoted unless you edit your question to show us sample data, expected outcome and what you've tried so far.
– cybernetic.nomad
Nov 8 at 18:16
add a comment |
2
Your question is likely to get downvoted unless you edit your question to show us sample data, expected outcome and what you've tried so far.
– cybernetic.nomad
Nov 8 at 18:16
2
2
Your question is likely to get downvoted unless you edit your question to show us sample data, expected outcome and what you've tried so far.
– cybernetic.nomad
Nov 8 at 18:16
Your question is likely to get downvoted unless you edit your question to show us sample data, expected outcome and what you've tried so far.
– cybernetic.nomad
Nov 8 at 18:16
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
Without really seeing what you are looking at. If both brought into the spreadsheet (assuming this isn't an ongoing changing item) you could use conditional formatting asking Excel to highlight the duplicate values then using auto filter filter by colour.
answered Nov 8 at 19:25
BradR
364
add a comment |
up vote
0
down vote
It sounds like you want to filter your first sheet for only values that are found in your second sheet?
If that is the case, I would a create a new column in your first sheet, and enter a formula like:
"=COUNTIF(Sheet2!B:B,Sheet1!A2)"
The first argument points to your second sheet, and the second argument points to the first ID in your first sheet. Drag down the length of the column as far as you need.
After this, you can filter your new column to exclude the zero value.
Just change the cells in the above formula to point to where you want in the workbook.
answered Nov 9 at 0:53
William O'Connor
63
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Without really seeing what you are looking at. If both brought into the spreadsheet (assuming this isn't an ongoing changing item) you could use conditional formatting asking Excel to highlight the duplicate values then using auto filter filter by colour.
answered Nov 8 at 19:25
BradR
364
add a comment |
up vote
0
down vote
Without really seeing what you are looking at. If both brought into the spreadsheet (assuming this isn't an ongoing changing item) you could use conditional formatting asking Excel to highlight the duplicate values then using auto filter filter by colour.
answered Nov 8 at 19:25
BradR
364
add a comment |
up vote
0
down vote
up vote
0
down vote
Without really seeing what you are looking at. If both brought into the spreadsheet (assuming this isn't an ongoing changing item) you could use conditional formatting asking Excel to highlight the duplicate values then using auto filter filter by colour.
answered Nov 8 at 19:25
BradR
364
Without really seeing what you are looking at. If both brought into the spreadsheet (assuming this isn't an ongoing changing item) you could use conditional formatting asking Excel to highlight the duplicate values then using auto filter filter by colour.
answered Nov 8 at 19:25
BradR
364
answered Nov 8 at 19:25
BradR
364
answered Nov 8 at 19:25
BradR
364
answered Nov 8 at 19:25
BradR
364
364
add a comment |
add a comment |
up vote
0
down vote
It sounds like you want to filter your first sheet for only values that are found in your second sheet?
If that is the case, I would a create a new column in your first sheet, and enter a formula like:
"=COUNTIF(Sheet2!B:B,Sheet1!A2)"
The first argument points to your second sheet, and the second argument points to the first ID in your first sheet. Drag down the length of the column as far as you need.
After this, you can filter your new column to exclude the zero value.
Just change the cells in the above formula to point to where you want in the workbook.
answered Nov 9 at 0:53
William O'Connor
63
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
add a comment |
up vote
0
down vote
It sounds like you want to filter your first sheet for only values that are found in your second sheet?
If that is the case, I would a create a new column in your first sheet, and enter a formula like:
"=COUNTIF(Sheet2!B:B,Sheet1!A2)"
The first argument points to your second sheet, and the second argument points to the first ID in your first sheet. Drag down the length of the column as far as you need.
After this, you can filter your new column to exclude the zero value.
Just change the cells in the above formula to point to where you want in the workbook.
answered Nov 9 at 0:53
William O'Connor
63
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
add a comment |
up vote
0
down vote
up vote
0
down vote
It sounds like you want to filter your first sheet for only values that are found in your second sheet?
If that is the case, I would a create a new column in your first sheet, and enter a formula like:
"=COUNTIF(Sheet2!B:B,Sheet1!A2)"
The first argument points to your second sheet, and the second argument points to the first ID in your first sheet. Drag down the length of the column as far as you need.
After this, you can filter your new column to exclude the zero value.
Just change the cells in the above formula to point to where you want in the workbook.
answered Nov 9 at 0:53
William O'Connor
63
It sounds like you want to filter your first sheet for only values that are found in your second sheet?
If that is the case, I would a create a new column in your first sheet, and enter a formula like:
"=COUNTIF(Sheet2!B:B,Sheet1!A2)"
The first argument points to your second sheet, and the second argument points to the first ID in your first sheet. Drag down the length of the column as far as you need.
After this, you can filter your new column to exclude the zero value.
Just change the cells in the above formula to point to where you want in the workbook.
answered Nov 9 at 0:53
William O'Connor
63
edited Nov 14 at 2:11
answered Nov 9 at 0:53
William O'Connor
63
answered Nov 9 at 0:53
William O'Connor
63
answered Nov 9 at 0:53
William O'Connor
63
63
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
add a comment |
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hello, basically I have an excel sheet with various columns and another excel sheet with one column containing some IDs, I want to filter the first sheet using the values in the column in the second sheet to get just the rows containing those IDs. The values are numeric IDs.
– Raziel
Nov 9 at 10:50
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
Hi, I may be misunderstanding your request, but it sounds like you want to filter your first sheet for only values that are found in your second sheet? If that is the case, I would a create a new column in your first sheet, and enter a formula like "=COUNTIF(Sheet2!B:B,Sheet1!A2)" - The first argument points to your second sheet, and the second argument points to the first ID in your first sheet - Then drag down. After this, you can filter your new column to exclude the zero value. Does that sound close to what you're trying to do?
– William O'Connor
Nov 12 at 0:24
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
thank you, I found the solution yesterday and it was exactly what you wrote :) I used the COUNTIF function!
– Raziel
Nov 13 at 1:02
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
No worries! I'll update my answer for any future users encountering the same problem.
– William O'Connor
Nov 14 at 2:09
add a comment |
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%2f1373848%2ffilter-excel-table-matching-two-columns-values%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
2
Your question is likely to get downvoted unless you edit your question to show us sample data, expected outcome and what you've tried so far.
– cybernetic.nomad
Nov 8 at 18:16