Count of Unique Values

[Datatellsall2]

Hello,

I'm trying to calculate how to count unique values based on a column set. I only want to produce what's in column 2, and have the rest of the cells be blank. Please see below as an example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Unique Identifier [/TD]
[TD]Unique Value[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]101[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
Matt

 

[JoeMo]

Copy B2 down.

Excel Workbook
	A	B
1	Unique Identifier	Unique Value
2	100	100
3	100
4	101	101
5	101
6	101
Sheet19

 

[Datatellsall2]

Thank you so much!

 

[JoeMo]

Thank you so much!

You are welcome - thanks for the reply.