rotmanite11
New Member
- Joined
- Aug 21, 2014
- Messages
- 6
Hi there,
I have a question I am trying to solve. I have used INDEX/MATCH/ROW/SEARCH functions, in different permutations, but I am unable to get the result. I am hoping one of the Excel experts can help me out:
The data set is something similar to the below:
<tbody>
</tbody>
I want to be able to do following (2 separate tasks):
Task 1 (if in A1 on a new sheet, I had Use, i want to list all the items in an adjacent column, skipping the blank rows)):
<tbody>
</tbody>
Task 2 (if i had Honda (A2) and North (B2), I want to have the colors listed in Column 3):
<tbody>
</tbody>
I know this can be done by an auto-filtering or manual sort, but I have work with thousands of similar data on a regular basis, and i want to find a formula that will allow me to list the items based on different criterion.
Thanks for your help.
I have a question I am trying to solve. I have used INDEX/MATCH/ROW/SEARCH functions, in different permutations, but I am unable to get the result. I am hoping one of the Excel experts can help me out:
The data set is something similar to the below:
Car | Region | Own | Use | Color |
Honda | North | Yes | I use it to go for work | Green |
Toyota | South | No | Family trips | Grey |
BMW | East | Yes | Weekend fun | Blue |
Ford | North | Yes | Yellow | |
Honda | North | Yes | 2nd car | White |
Toyota | West | No | Work | Green |
<tbody>
</tbody>
I want to be able to do following (2 separate tasks):
Task 1 (if in A1 on a new sheet, I had Use, i want to list all the items in an adjacent column, skipping the blank rows)):
Use | I use it to go for work |
Family trips | |
Weekend fun | |
2nd car | |
Work |
<tbody>
</tbody>
Task 2 (if i had Honda (A2) and North (B2), I want to have the colors listed in Column 3):
Car | Region | Color |
Honda | North | Green |
White |
<tbody>
</tbody>
I know this can be done by an auto-filtering or manual sort, but I have work with thousands of similar data on a regular basis, and i want to find a formula that will allow me to list the items based on different criterion.
Thanks for your help.