Extract data qty less then 40

[mathanraj76]

Hi..

I have data in ms excel and in column "F" is the Qty

If the Qty is Less then 40 then extract the data and put into the sheet "Less then 40"

I have attached sample excel file


Thanks

[AB33]

Try the attached.

[alansidman]

Try this:

Please Login or Register  to view this content.