Up to and including

[CoenH]

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

[Paul]

Perhaps:

Please Login or Register  to view this content.

Slight edit to formula for parentheses error.

[CoenH]

Paul,

Awesome! Thank you!