filtering?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi, I am a complete newbie to Excel. I have a report
from quickbooks pos exported to excel that i would like
to filter. Among the multiple columns are an on hand
quantity in one and another column with reorder point.
If the 2 numbers match, i would like to have that row
filtered out. In other words, only show me the rows of
items where the 2 columns have different values. Any
help would be greatly appreciated. Thank you!
 
You can add a column to your table, and use it to calculate whether the
fields match. For example, if On Hand is in column B and Reorder is in
column C, enter the following formula in the new column:

=IF(B2=C2,"","X")

Copy the formula down to all rows, then filter that column for X

Or, to find rows where the OnHand is less than or equal to the Reorder
point:
=IF(B2<=C2,"X","")
 
Back
Top