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,