[Solved] Formula for working out 'the best'

[neil-uk]

Hi Guys,

I am working on a spreadsheet, and looking for some guidance on a calculating formula. I really don't know what to use, so advice would be appreciated

If we say for example it's a cafe, and food being served at certain times of the day, I want to know the 'best' and the 'worst' times for selling those items.

I've attached an example file of what the data I am looking for is - what I am struggling for is the data in Red, in the sheet.

Can anyone help?

Thanks!
N

[Villeroy]

Your data layout is too complex.
Nevertheless,
K5: =INDEX($E$3:$I$3;1;MATCH(MAX($E5:$I5);$E5:$I5;0))
should get the best time. Replace MAX with MIN for the worst time.

It could be easier to maintain and you could get far more information from sales data if you would use a normalized table.
See viewtopic.php?t=101434

[neil-uk]

Hi,

This works perfectly for me, thanks!