Hello,
Sorry about the title, once someone gives me some guidance on what it should be, i'll change that.
Here's my issue.
I've got an excel sheet with 87k rows on it. The important columns for my question are the sales order column, and the items column. Each sales order gets a row for each item, so it looks like this.
1 AA
1 BB
1 DD
2 AA
2 FF
3 CC
3 DD
3 EE
4 TT
5 AA
5 ZZ
What i need to be able to do, is search the sheet for a specific item, "AA" for example, and pull up the sales order, and any other items that are on that order.
So in this example, i'd need to see...
1 AA
1 BB
1 DD
2 AA
2 FF
5 AA
5 ZZ
Sorting and filtering just got me the sales order number with AA, but not the other rows with the other items on it. I was looking at a pivot table, but didn't have much luck there either.
Any ideas?
Thank you,
Bookmarks