Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Formula help - MIN

Hello,

I need a formula that will extract the MIN of the Opening Balance as fond in row 2 but for 5 days date range after the expense as shown in row 11.

I have uploaded a sample.

thank you very much...
EE_after.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ainsley Rood
Ainsley Rood
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Raheman M. Abdul
Raheman M. Abdul
Flag of United Kingdom of Great Britain and Northern Ireland image
Formula to use:  =IF(ISBLANK(B11),,MIN(B2:OFFSET(B2,0,5)))
see attached.
EE_after_V2.xlsx
Avatar of Shums Faruk
Shums Faruk
Flag of India image
Formula for getting 1st minimum excluding 0:
=SMALL(C2:G2,COUNTIF($C$2:$G$2,0)+1)

Open in new window

Array Formula for getting 3rd minimum with Cntrl+Shift+Enter
=SMALL(IF(H2:BO2<C18,H2:BO2),1)

Open in new window

Formula for getting 2nd minimum:
=SUMPRODUCT(($H$2:$BJ$2>$C$20)*($H$2:$BJ$2<$C$18)*($H$2:$BJ$2))

Open in new window

Please find attached for your reference.
EE_after.xlsx
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

Sorry I am having Internet issues. I will check again in a while. I am responding from my phone. I cannot download the files
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

Ainsley, that worked!  Very nice.   When I initially looked at it I thought that will not work but I see that it always goes five cells to the right even though it doesn't seem like it would.   I probably didn't do a very good job explaining that but it works perfectly
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

I am going to ask a similar question.