I Understand there are many similar questions, but i cant find the answer anywhere.
My problem is that have 40.000 rows in an excel document, and i need to count how many times each requester appears in a column.
I have found the the function "COUNTIF()", but as i understand it needs a criteria. As there are 40.000 rows, i dont want to go all of them through to get the criteria for the fucntion and waste my time.
Is there a function to count all marked cells/marked column and then sorts them so it displays in a table of some sorts how many times each name appears?
Fx=COUNTIF(E:E,Ex)
. For example, in F2 it is=COUNTIF(E:E,E2)
.Requester
to both the Rows and Values section and it will give you a sorted, unique listed of Requesters and a count of how many times they appear in the table.