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.