General discussion
-
Topic
-
Excel formula
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 35For 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 weekI 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