Looking for a way to do the following, using an excel sheet
Every week, entries are made to a sheet, abc company, 123 company, efg company etc.
Is there a formula I can use that at the end of the week
It takes all the same named companies, makes a list, with the amount of of times that company was entered so end result would be something like abc company 24, efg company 18, 123 company 35
For now, the entries have to be on a single line/cell, but are trying to see how many times that company engaged with us in a weekly basis
And make it easily readable in a list at the end of the week
I know I am probably making this more difficult than what I need it to be, but this is what it is for now….any and all suggestions would be appreciated, thanks