Excel Autofilter help

[Ross]

Hi all!

Does anyone know why when I use the autofilter to filter a set of data in Excel to show lets say just records with "421" in the "Fleet Number" column, it removes thousands of blank rows aswell and then shows a blank row at row # 6023 for example?

It used to just display all the 421 records and the next available blank row so I could fill in another record for fleet # 421 but not anymore it skips 6000 rows.

Hope you can understand what I mean lol.

Thanks a lot,

Ross

 

[SourChipmunk]

Not really understanding, but is it possible there is both a text version of 421 ('421) and a numerical version? Check the autofilter dropdown and see if there is another instance of it.

Which version of Excel are you using?

 

[Nash]

Are the cells all formatted the same?