[Solved] Formula for working out 'the best'

Discuss the spreadsheet application

[Solved] Formula for working out 'the best'

Postby neil-uk » Tue Mar 31, 2020 11:04 am

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
Attachments
Example .ods
(12.62 KiB) Downloaded 17 times
Last edited by MrProgrammer on Tue Mar 31, 2020 7:37 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
NeoOffice 2.2.3 with MacOS 10.4
neil-uk
 
Posts: 26
Joined: Sun Nov 07, 2010 1:01 am

Re: Formula for working out 'the best'

Postby Villeroy » Tue Mar 31, 2020 12:08 pm

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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28431
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Formula for working out 'the best'

Postby neil-uk » Tue Mar 31, 2020 5:50 pm

Hi,

This works perfectly for me, thanks!
NeoOffice 2.2.3 with MacOS 10.4
neil-uk
 
Posts: 26
Joined: Sun Nov 07, 2010 1:01 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests