You can highlight with conditional formatting. With your data in cells
A2:B7, it would be

=AND(COUNTIF($A$2:$A$7,$A2)=1,$B20)

with the conditional format, whatever you like to highlight things.

For extraction, you can put the above formula in an adjacent column,
and use Advance Filtering. The formula above should evaluate to True
for rows meeting your conditions, otherwise False, as I understand
your problem.

Good luck.

Ken
Norfolk, Va


On Jun 21, 8:10 am, Diamonds_Mine
wrote:
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