Prev: Ignore Hidden Rows and Count of distinct values
Next: Combining Cells
From: Ashish Mathur on 12 Apr 2010 20:57
Hi,

=if(or(A1=A2,countif(A$1:A1,A1)=1),"",countif(A$1:A1,A1))

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Soth" <Soth(a)discussions.microsoft.com> wrote in message
news:71AD4304-84EC-4D54-93FC-FBE82689F856(a)microsoft.com...
>
> Result
> Example
>
> Result in col B
> A B
>
> 100
> 100
> 100 3
> 200
> 300
> 300 2
>
> Hi
>
> I'd like to find the number duplicates in Column A, and place a result in
> column B as shown on above in Col B. How do you create formulas?
>
> Thanks
> Soth
>
First  |  Prev  | 
Pages: 1 2
Prev: Ignore Hidden Rows and Count of distinct values
Next: Combining Cells