I have data in column C and E. The values in both these columns is random. I'm looking for the highest value to be returned in column I. So I have =MAX in column I. I would like column J to return which winning column this was taken from. So my labels for column C & E are in listed in C3 & E3. What formula can I use to return these?
My Random data is in Col C7 Col E7
Col Labels are Col C3 Col E3
My winning selection is in I7
Would like The data in Col J7 to be returned from either C3 or E3 based on the value in I7.
Can you help?