Good afternoon,
Is there a formula to count the city that shows the most in the below 6 cells?
I was going through countifs and everything, but it seems I will need something more complicated...
I'm looking for the next cell to basically result in "Sacramento" here since they show 4 out of 6 times.
Sacramento 1
Sacramento 0
Sacramento 1.6
Washington 0.6
Washington 1.6
Sacramento 5.7
Also, would it be possible to factor in the average and result in Sacramento 2.075 ?
Thanks for the help!!
Bookmarks