helpmeob1wan
New Member
- Joined
- Aug 27, 2018
- Messages
- 1
I have a spreadsheet with authors of articles in one column. Many of the authors have several entries, and there are 100 rows total.
For example
[ Author t, Author u, Author v]
[ Author x, Author Y, Author z]
[ Author A, Author b, author x]
I have to find out how many times the authors are repeated i.e. how many authors wrote more than one article in the list. One way to do it is to manually go through each name 'CTRL + F' it and see how many other times it appears in the sheet.
Is there any automated way I can do this that will save me time?
Thanks for any help in advance.
For example
[ Author t, Author u, Author v]
[ Author x, Author Y, Author z]
[ Author A, Author b, author x]
I have to find out how many times the authors are repeated i.e. how many authors wrote more than one article in the list. One way to do it is to manually go through each name 'CTRL + F' it and see how many other times it appears in the sheet.
Is there any automated way I can do this that will save me time?
Thanks for any help in advance.