advanced filter with criteria list with numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you help?

I have a criteria list with numbers in a column:

ID#
12
15
45
76

How can I make Excel stick exactly to these criteria, rather than filtering
also records with ID# 125, 151, 4577, 76032, etc.?

Thank you!
 
Works for me, maker sure you have real numbers. if you filter text values
with numbers they will
return that way but not real numbers. You can try to see if this helps

=12
=15
=45
=76




where each cell will look like

="=12"

and so on


--


Regards,


Peo Sjoblom
 
Thank you, Peo. (-:
Worked for me in a new spreadsheet.
Will figure out what is wrong with my old one.
Probably some text format, as you suggested.
 
Back
Top