May 02 2022 08:14 AM
I have a spreadsheet to track how many reports each associate performs per month. At times 2 or more associates work on a report together but my formula will not count that report towards all associates listed.
For example, 2 associates work on a report together, lets call them Bill and Bob. Bill's name is listed first in cell G3 and Bob is listed second in cell G4 so both Bill and Bob should get credit for that report but my current formula will only give credit to the first name listed which is Bill, if I switch the names and put Bob in cell G3 and Bill in cell G4 then only Bob gets credit. What formula can I use to give all associates credit for the report?
I am currently using the countif formula to count how many times an associate name appears in column G but again for some reason only the first name listed for each report gets credit for that report.
May 02 2022 08:18 AM
May 02 2022 08:26 AM
May 02 2022 08:41 AM
Thank you. And what is output? You say "how many reports each associate performs per month", if so you may count Bill by name, doesn't matter which report. Or you count how many associates per report or something else?
May 02 2022 09:08 AM
May 02 2022 11:19 AM
The easiest and most correct way is to keep source data without blanks, i.e. like this
How to fill down existing data is explained here Fill Down Blank Cells Until the Next Value in Excel (3 Easy Ways) - Trump Excel