Counting Names Separately [Closed]

Report
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Hello,

I would like to request that how to count names separately if in any one columns contains more than one names. Such as it is given below:

means that how many times any name is shown before and after this separator "/" whether "/" is not necessary only the First Name is also acceptable

Ashqeen / Ishaq
Ashqeen / Tahseen
Ashqeen / Arsalan
Ashqeen / Ishaq
Tariq / Arsalan
Ashqeen / Ishaq
Asif / Junaid
Ashqeen / Tahseen
Tariq / Arsalan
Ashqeen / Ishaq
Tariq / Mehboob
Ashqeen / Ishaq
Ashqeen / Mehboob
Ashqeen / Junaid
Areeb
Tariq / Areeb
Areeb
Tariq / Arsalan
Ashqeen / Areeb
Tariq / Ishaq
Ashqeen / Mehboob
Junaid

Thanks

1 reply


OK, so post some code or your sheet so that we can take a look at it.....

Is this for School, or class work?
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
Hi ac3mark
As per your order Respected Sir, here is the link given below for your query

http://speedy.sh/8aqks/Duties.xlsm

Thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!