Help on filter

  • Thread starter Thread starter sylvain
  • Start date Start date
S

sylvain

HI,
I have a list to filter. I have to keep only integers.
I tried everything in advanced filters... does not work.
Can you help me please?
Thanks
Sylvai
 
Hi
one way: use a helper column. Lets say your numbers are in column A
then enter the following formula in an adjacent cell for row 2
=IF(MOD(A1,1)=0,"X","")
copy this down for all rows. After this filter with this helper column
 
Sylvain

Would Edit>Go To>Special>Constants and uncheck all but "numbers" do the trick?

Gord Dibben Excel MVP
 
Back
Top