Sort !

[shibulal]

Hi,


Once again....


I have a worksheet with cheque status.

The results coming in to the worksheet is produced thru vlookup command.

How can I autofilter a worksheet avoiding blank rows ?

(I used IFFERROR formula to make the column blank.)


Regards,

Shibu

 

[Luke M]

You should be able to set your AutoFilter to hide blanks. Is this not working for you?

 

[shibulal]

Good Morning Luke,


No it is not working or Im not expert in Filtering.....

Could you please guide me ?

 

[nazmul_muneer]

At first Select the Range (up to bottom)

Go to Data Tab

Click on Filter

Click on Auto filter combobox on data range

Uncheck (Blanks)