| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Data in Excel 2003
Below is a sample list; I need to extract or highlight names in Column A that
have a zero value in column B, but if the name in Column A is listed multiple times and the value in column B is greater than zero, it should not be extracted or highlighted. So for the list below the result should be User 4 and User 5. Thank you. Column A Column B Name PST Folder Size User 1 0 User 2 15 User 3 18 User 1 22 User 4 0 User 5 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Taking out unsubscribed emails by comparing 2 Excel files (Excel 2003) | Excel Discussion (Misc queries) | |||
| comparing excel 2003 and excel 2007 | Excel Discussion (Misc queries) | |||
| Excel data comparing | Excel Worksheet Functions | |||
| excel 2003 help comparing prices for lowest | Excel Worksheet Functions | |||
| Comparing a value to a list of values does not work in Excel 2003. | Excel Worksheet Functions | |||
Threaded Mode
