vendredi 28 juin 2019

Making a cell in column B display the largest value in column A

I have 2 columns, H&I with numbers. The values in H correspond to different ID numbers, and I has measurements.

I am trying to figure out a formula that would post in cell K3 the highest value in column I. I also want cell L3 to say the corresponding value in column H (relative to the new highest value/new value of cell K3).

I tried to figure out an if statement that works, but I couldn't get it just right.

Aucun commentaire:

Enregistrer un commentaire