View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diamonds_Mine Diamonds_Mine is offline
external usenet poster
 
Posts: 2
Default 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