| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Filter with data in two columns
easiest way is to add a 3rd column and do =B1-A1, then put the filter on.
Filter by column C (custom) is less than 0. "Princess V" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter imported data to columns | Excel Worksheet Functions | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| Filter data based on multiple columns | New Users to Excel | |||
| I've put data to columns - counted - need dropdown filter | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
![Princess V[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
