Forum Discussion
Entering the wrong profile
I have a project to do in metallic structures, and in one of the cases I need to say which profile is approved with the lowest mass, but when I do this it is returning the wrong value. It works as fo...
HansVogelaar I created the same situation in Google spreadsheet with the same name as the Excel function, if you could try I would appreciate it
https://docs.google.com/spreadsheets/d/10VLBcuXKYhj8hZQF4FbMfAhtglpqyFvMfYbjRQMTGE4/edit?usp=sharing
Thanks. In your sample workbook, the formula in J3 should be:
=MINIFS(H4:H62,F4:F62,"APROVADO")
=MÍNIMOSES(H4:H62;F4:F62;"APROVADO")
and the formula in M2:
=INDEX(E4:E62,MATCH(1,(F4:F62="APROVADO")*(H4:H62=J3),0))
=ÍNDICE(E4:E62;CORRESP(1;(F4:F62="APROVADO")*(H4:H62=J3);0))
In the MATCH part, we have to add the condition on APROVADO too. And we have to specify 0 as 3rd argument, because we want an exact match.
See the attached version.
- This function was very good, thank you for your help.