Counting data duplicates across columns

[sahsinha]

Hello Friends,

I am seeking your help after trying several things.

Problem : I have an excel sheet for everyday data across columns.

So Column A will have a set of data -> Alan, Bosch, Case, Dodge, Elan, Fiama and so on (around 50) for 01st Jan
Column B will have a set of data -> Aron, Bell, Carol, Dodge, Eric and so on (around 50) for 02nd Jan....
Similarly Column C, D, E, etc. for a month.

There can be common data across the columns as in the above case it is Dodge.

I want to find the number of occurrence of any data without searching for that particular data. Count will only work if I know what I want to count.

I want 2 separate columns one with the data and the next indicating the number of occurrences. So if Dodge appears on 01st Jan, 02nd Jan, 10th Jan and 20th Jan then I have something like ->
Dodge 4

and so on.

Look forward to your help and thanking you in advance.

[dilipandey]

HI sahsinha,

welcome to the forum.

Try using below formula:-

Please Login or Register  to view this content.

see attached:- counting data duplicates.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[sahsinha]

Hello Mr. Pandey,

Thanks a ton for your help.

Frankly I lost hope that anyone would reply - but you have indeed been very kind.

Cheers,
Sahil

[dilipandey]

You are welcome Sahil... cheers


suggest you to mark this thread as [SOLVED]. Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[sahsinha]

Done - marked as solved. :-)