View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Princess V[_2_] Princess V[_2_] is offline
external usenet poster
 
Posts: 8
Default Using Filter with data in two columns

I want to identify rows in my spreadsheet based on criteria in two rows.

Example:
A B
1 5 6
2 4 2

In the above example, I want to filter the sheet two display the rows for
which value in column B minus the value in Column A is a negative value.

How could i do this?