How to Count unique values in a single column

[Twinkievizzio11]

Hello,

What formula can I use to count unique values in a single column located on a worksheet named "Prior"?

Example:
Worksheet name ""prior" column D has the following information which is in text format

11111
22222
11111
33333
33333
44444
55555
11111
55555

I need a formula that will count the number f unique values totaling 5

Please help!

Thank you

 

[Fluff]

That shouldn't matter, as long as they are all text.

 

[Twinkievizzio11]

Thank you again. It worked!!

If I want to add that C5:C10 does not equal C3?

 

[Fluff]

Simply change the = to <> and reconfirm with Ctrl Shift Enter

 

[Twinkievizzio11]

When I change the = to <> I get an #N/A

 

[Fluff]

works for me (all values are text)

Excel 2013/2016
	C	D
3	20181	3
4
5	20181	11111
6	20182	22222
7	20181	22222
8	20182	33333
9	20182	11111
10	20181	22222
Sheet6

Cell Formulas
Range	Formula
D3	{=SUM(--(FREQUENCY(IF(C5:C10<>C3,MATCH(D5:D10,D5:D10,0)),ROW(D5:D10)-ROW(D5)+1)>0))}
Press CTRL+SHIFT+ENTER to enter array formulas.