Howto extract a subset of data without coding at all ?

[Radu]

Sheet 1 has the first column named "PINS" containing, say, 1000
different PINS, each PIN having 1...N records. I need to show only a
subset of those 1000 PINS - say 50 PINS.

On sheet 2 I create a column named "SubsetPINS" with 50 records. How
do I filter the spreadsheet 1 so that it shows only the records for
the 50 PINS specified in Sheet2!$A:$A ?

Of course, I could run some VBA code, or I could run the query in
Access, but how would one (without Access, and without VBA coding
knowledge) solve this problem ?

Thank you.
Alex

 

[Peo Sjoblom]

What's wrong with the other solutions?
You can use a countif formula to tag each value based on the subset and then
autofilter or you can use advanced filter, hardcoded criteria would take up
50x50 cells or you could use a formula s advanced filter criteria like

=ISNUMBER(MATCH(Sheet1!A2,$A$1:$A$50,0))


--


Regards,


Peo Sjoblom