How to count unique records in a column?

[Rev12]

Hi!

I need a help of counting unique records as example below

Column A
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-MP-05-001
HP-S30-MP-05-001
HP-S30-MB-07-012
HP-S30-MB-07-012
HP-S30-MB-07-012
HP-S30-MB-07-012

I need the result as below

Column A Column B
HP-S30-A-01-001 1
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-MP-05-001 1
HP-S30-MP-05-001
HP-S30-MB-07-012 1
HP-S30-MB-07-012
HP-S30-MB-07-012
HP-S30-MB-07-012


Any help is really appreciated.

Thanks in advance.
Rev12

 

[Joe4]

Assuming your values start in row 1, if your values in column A are always sorted, you can place 1 in cell B1, and then this formula in cell B2 and copy down for all rows:

=IF(A2=A1,"",1)

 

[Rev12]

Hi!

I need a help of counting unique records as example below

Column A
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-MP-05-001
HP-S30-MP-05-001
HP-S30-MB-07-012
HP-S30-MB-07-012
HP-S30-MB-07-012
HP-S30-MB-07-012

I need the result as below

Column A Column B
HP-S30-A-01-001 1
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-MP-05-001 1
HP-S30-MP-05-001
HP-S30-MB-07-012 1
HP-S30-MB-07-012
HP-S30-MB-07-012
HP-S30-MB-07-012


Any help is really appreciated.

Thanks in advance.
Rev12

What I really need is to count unique records, for example

in Column A5:A11

HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-MP-05-001
HP-S30-MP-05-001

I need a result in B5:B11 that would count as 1 even it's a duplicated as below

Column A5:A11 B5:B11
HP-S30-A-01-001 1
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-A-01-001
HP-S30-MP-05-001 1
HP-S30-MP-05-001


thanks in advance for any help.

Rev12

 

[Joe4]

I need a result in B5:B11 that would count as 1 even it's a duplicated as below

That is exactly what the formula I gave you should do. Did you try it?
Just adjust it for your range by placing this formula in B5 and copy down.

=IF(B5=B4,"",1)

If you do that, it should look EXACTLY like the desired output you show.