Data Filter

[sambit]

Sir,
Please help to resolve the issue to filter the data as per the criteria.

Attached the Example file for your kind information.

 

[vletm]

sambit
Something like this ...
Note #1: Dates should write as Dates - even Your 'Months'
Note #2: Your file has something which don't work with my Excel-version.

 

[sambit]

Vletm Sir,
Excellent.

Thank you very much.

All the criteria are working fine except Invoice Qty.

For example:-
if we have taken heading as Invoice Qty in cell "C4" and in Cell "C5" put 21.430 as qty

The result does not show after a click on Filter Command Button

 

[vletm]

sambit
a) select 'Invoice Qty'
b) write 21.430 to 'C5' and press <ENTER>
c) press [ Filter ]
d) see the results ... if not then try to scroll Your sheet to top ... manually

 

[sambit]

Vletm Sir,

Thanks for your reply.

I have observed if we manually write the qty then the Filter command working fine. if you copy and paste the qty data then it does not working.

 

[vletm]

sambit
If use eg 'copy&paste' ... it should know how?
If cell will be after paste still in 'edit'-mode then even [ FIlter ] won't work ... or will.
After <ENTER> ( finish editing ), it should work better.