Hi,
I would like to extract values from excel that belong to the numbers 100, 101 and 102. However, I only have access to the highest and lowest numbers. So in this case 100 and 102. These three numbers are all variable so I really have to do with the highest and lowest numbers. Is there a 'from to' function in Excel?
=MAXIFS(INDIRECT($H$7&"!M:M"),INDIRECT($H$7&"!B:B"),">="&MINIFS(INDIRECT($H$6&"!E:E"),INDIRECT($H$6&"!A:A"),B3),INDIRECT($H$7&"!B:B"),"<="&MAXIFS(INDIRECT($H$6&"!E:E"),INDIRECT($H$6&"!A:A"),XXXX))
In this case, cell A1 is 100 and cell A2 is 102. Must be inserted at the 'XXXX'
Many thanks
Bookmarks