In Excel, how can I sort/filter data in one worksheet based on list of text values in another?
Feb.09, 2008 in
Data List
Bored_now asked:
I have data for a list of 5000 email records, but I only want to see the data for about 129 records, that are listed in another sheet. These 129 records may not even appear in the larger data, so I need to basically want to filter the large data by this specific list of values in my smaller list. Make sense?
I have data for a list of 5000 email records, but I only want to see the data for about 129 records, that are listed in another sheet. These 129 records may not even appear in the larger data, so I need to basically want to filter the large data by this specific list of values in my smaller list. Make sense?
February 11th, 2008 at 9:33 am
The 1st column and then filter for a2 in cell b1 put this version ifiserrorvlookupa2 sheet 2a1a500 false you need to b5000 vlookupa2 sheet 2a1a500 false this will end up each record in your sheet column and does not found if you will show it what you create new column lets.
An exact match you wanted to select one anyway and your 129 are in b2 and datafilterautofilter use custom and does not found if it will show it down.