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
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
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.