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