Thread: Combined MAX and IF statements?
View Single Post
 
Old 06-30-2017, 11:55 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
The location for the highest nr of " beds" can be obtained by =INDEX('RAW DATA'!$A$6:$A$12;MATCH(MAX('RAW DATA'!B$6:B$12);'RAW DATA'!B$6:B$12;0))
pull right for other values
For the lowest, the same, using MIN instead of MAX

This will work as long as the three columns stay in the same order on both pages.
If not, some tweaking is necessary but easy to do.

OTH what should happen if there is more than one MAX or MIN?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote