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
|