Hi, hoping someone can help.

I have an excel spreadsheet, looks something like this
Column A Column B
$10,000 A
$20,000 B
$60,000 A
$70,000 B
$80,000 B
etc etc

What I have currently is something that provides me counts, for example:

0 - 49,999 based off an "A" in column B would equal 1
0 - 49,999 based off a "B" in column B would equal 1
50,000 - 99,999 based off an "A" in column B would equal 1
50,000 - 99,999 based off a "B" in column B would equal 2

My data looks now something like this, where Instances and Unique are two columns, I have a countifs statement to provide me the count of instances, but would like it to populate how many unique instances there are. Thanks again in advance!

----------------------Instances ---- Unique
0<50,000------------ 50
50,000<100,0000 --- 20