CODEWITHSUNDEEP
excelexcel-formula
lenhhoxung
lenhhoxung

Reputation: 2746

Excel Filter works badly

Helo Everyone, I have a problem with filter, please help me. I used filters before and everything was ok. Today, I imported data from a text file. After importing data, I used a filter as in the attachment and rows don't meet criteria still appear. Can you help me?enter image description here

Upvotes: 0

Views: 69

Answers (1)

Byron Wall
Byron Wall

Reputation: 4010

Looks like the filter was not applied to the whole range of cells. Since there is a line there that appears to be all blank (row 211), the filter may have stopped at that spot instead of covering all the data.

If you select all the cells (really columns A:C) and apply the filter again, it should probably work.

Upvotes: 2

Related Questions