Jezabelinka
New Member
- Joined
- Sep 4, 2018
- Messages
- 1
I admit I am a bit stupid on this subject...
I have a table with 7 different colums
I need on colum H to retrieve the lowest value from colum G - as long as this is the lowest amongst the relevant rows
Coloms A, B & C are the filtering colums, they all have to match
I tried making colum H my CONCATENATE colume with info from A+B+C, and then in colum I to do the SMALL(IF(),1) option, with no luck
Any suggestions?
I have a table with 7 different colums
I need on colum H to retrieve the lowest value from colum G - as long as this is the lowest amongst the relevant rows
Coloms A, B & C are the filtering colums, they all have to match
I tried making colum H my CONCATENATE colume with info from A+B+C, and then in colum I to do the SMALL(IF(),1) option, with no luck
Any suggestions?