I recieve a list (130+) of items that need to be found in a large spreadsheet (20,000+ items)
I want to filter this large spread sheet to show only the needed data.
I think I need a string express to do this and I know the format should be ="=item"
what I would like to do is be able to use a formula to make the small list of items I need into the string and then place this string into my filter.
I have attached a sample spreadsheet that I hope explains this better
sheet 1 shows the advanace filter (i manually typed in the sting expressions on this sheet" along with a sample of the data I will be using.
sheet 2 shows what I would like to be able to do make the string. Yes, it appears to work but when I copy the apparent string expression on this page and paste (evene with using paste special values only) excel does not look at the value as a string.
I hope this makes sense to someone and that someone can help.
Bookmarks