Easy data filtering but I can not figure it out

I have an inventory sheet and I'm trying to create a reorder list. All I want to do is to pull any row from the list range in which Qty. In ("J" column) is less than Reorder ("M" column) and put it in a new location in the worksheet. I have tried criteria as =J3<M3, Qty. In < Reorder,<M3, ="J3<$M$3:$M$..." nothing seems to work. If I put a real figure in (like 4) it works fine. Help!!!! I included a sample so you can see what I'm trying to do.

To use Advanced Filter with criteria you should set up a criteria row above the data rows.

The headers in the criteria must exactly match the header labels in the data.

You should place the "Qty. In" on the same row as the data headers.

In the criteria row header you only need "Qty. In" (w/o quotes) as the label to extract the data and using this (or a similar formula):

="=1"

In the Qty. In column, I would use this formula to return either a one ( 1 ) or zero ( 0 ) and then filter on values equal to 1 (shown above).

=IF(AND(ISNUMBER(M7),J7<M7),1,0)

IMO, I think it is a mistake to mix text ("By Order") in a column where numeric entries are expected as you have done. I would use a separate column. You have to decide how to treat the text entries relative to your formula and filtering needs.

The above formula, using AND, combines a comparison of the values along with testing if the cell value is numeric, using ISNUMBER function, before returning the result.

Palmetto, I made the changes you suggested and replaced the "By Order" with zeros. I used a variation on the formula you sent, =ISNUMBER(J7)*J7<M7 and moved the ("Qty. In") column label out of the criterion, seems to work.

Thanks for your help