megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
I have dates in Column A, person's name in B, locations in C. Each date, a name is assigned to a location, but that is not my circus ![Beaming face with smiling eyes :grin: 😁](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f601.png)
![Relieved face :relieved: 😌](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60c.png)
At the end of the month, I need to find out which location each name was assigned to the most.
The data is basically exactly like this but with 100+ potential names and 30 potential locations.
What I would like is something off to the side that just tells me which value was the most frequently occurring for each name. If it's a tie between locations, it's okay if it returns an error (or maybe it says "Manual") and then the person who does own this circus can use their judgment to decide.
![Beaming face with smiling eyes :grin: 😁](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f601.png)
![Relieved face :relieved: 😌](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60c.png)
At the end of the month, I need to find out which location each name was assigned to the most.
The data is basically exactly like this but with 100+ potential names and 30 potential locations.
What I would like is something off to the side that just tells me which value was the most frequently occurring for each name. If it's a tie between locations, it's okay if it returns an error (or maybe it says "Manual") and then the person who does own this circus can use their judgment to decide.