Excel (well, Google Sheet) help


#1

Yo team!

I reckon this will be a really simple one for youse…

I have two columns, one of numbers, one of days of the week these numbers happen. I basically want to see what day of the week, on average, gets the best number. I am sure there is a more scientific way of doing it that arranging the number from biggest to smallest and guessing which day seems to crop up the most. Any ideas?


#2

Do a pivot with days one, on count and one with to and divide. Probably an easier way.


#3

List of days, then this formula in cell next to each =MAX(IF($R:$R=I8,$S:$S))

R:R = days
S:S = numbers
I8 =day
Arrya formlua needed so press ctrl+shift+enter when completed


#4

Sorry I’m really dumb at this stuff - I replace R with the name of the column with the days in, right? And same for S with the numbers?


#5

So for instance (had to change the columns but its the same concept, sorry for the mess - in a rush:

I6 is Tuesday etc


#6

As with all Excel questions, the first piece of information to be considered is: am I doing this once, or am I going to do this many times? The answer always influences the best solution massively.


#7

Can you do pivots in Google sheets?


#8

Rosscouch.gif


#9

Shit I think I’ve done it!

(The answer seems to be Thursday).

Cheers s_a_d!


#10

Took me a crazy amount of time to work out it needed an array formula (I still dont really know what they do)