Find number of times certain words show up in a column

  • Thread starter Thread starter BRB
  • Start date Start date
B

BRB

I have a spreadsheet with roughly 2000 rows and 4 columns with column "A"
having model Par Numbers (which contain alphanumeric characters). I need to
end up with a count of how many times each PN shows up. The result can be in
the same sheet or a new one, but must be a list of unique PNs and their
respective count.
Since I have to do this twice weekly it becomes very time consuming to do it
manually. Can someone help me with this? Thanks,
 
Hi

To create a list of unique PN, select column A, goto Data > Advanced Filter
Action: Copy to another location > Copy to: select cell on current sheet >
Click to expand...
Check 'Unique records only' > OK

Suppose you have your unique list in E2 and down, enter this formula in F2
and copy it down as required:

=COUNTIF(A:A;"="&E2)

If you want to have it more automated, you will need a macro.

Regards,
Per
 
Back
Top