jeudi 27 octobre 2016

Max value from list where true

i have a sheet that looks similar to this

 A       B       C
 2016    5       TRUE
 2015    7       FALSE
 2016    8       TRUE
 2016    3       TRUE
 2015    5       FALSE

I need to show the highest value of B and its A where C is TRUE.

So i guess i would need 2 formulas to show this.

I know that i should probably use MAX and IF however, i can't figure out how to put this together.

So in this example the result i want is:

2016
8

Aucun commentaire:

Enregistrer un commentaire