Find unique values within column

[AmyS]

I am trying to find a way to identify unique numbers in the rate column for each ID number if it has Units. For example:

In this instance, I would not need to identify anything for the first ID because even though there are units all of the rates are the same but the second ID has one rate that is different (B10) as well as units. I would need that ID identified. I have tried conditional formatting as well as countifs but I have not been able to figure out a way to do this.

Any help would be appreciated.

 

[GraH]

If you are on Excel 365

=Unique(Filter(ID:Rates, Units>0))

Replace the column references in my fx with the data ranges of your actual data. If that's a table you can add the square brackets to have a formula working with structured references.

 

[AmyS]

If you are on Excel 365

=Unique(Filter(ID:Rates, Units>0))

Replace the column references in my fx with the data ranges of your actual data. If that's a table you can add the square brackets to have a formula working with structured references.

 

[AmyS]

Thank you both. Unfortunately, that formula shows any ID with units, not just those with a different rate.

In this example, I would have only wanted it to identify the second ID since it had a different rate amount.