Minimum Value Formula

[CokeOrCrack]

Is there a minimum value formula that meets the below points?

• Minimum value from a table column
• Multiple criteria
• Pulls the minimum value of the unhidden data from the filtered table column

I previously used a minimum value nested if formula (i.e. {=Min(If...,If(...)}, but I now need this to only pull the unhidden minimum when the table is filtered. Is this possible?

Thanks

 

[CokeOrCrack]

Resolved. Found the below online.

{=MIN(IF(Criteria1=x,IF(Criteria2=y,IF(Criteria3=z,IF(SUBTOTAL(109,OFFSET(Value_Field,ROW(Value_Field)-MIN(ROW(Value_Field)),0,1))>0,Value_Field)))))}