Previous Topic Next Topic

Counting Names Separately

Closed
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - May 17, 2016 at 12:12 PM
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - May 20, 2016 at 11:13 AM
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

Answer 1 / 1
Blocked Profile
May 17, 2016 at 04:28 PM
OK, so post some code or your sheet so that we can take a look at it.....

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

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

Thanks
0