H hopback Mar 16, 2006 #1 I have the following formula perform a data sort. {=(ADDRESS(MIN(IF(E2:E483=G2,ROW(D2483))),COLUMN(D2483),4))} How do I convert the resulting cell address to the cell value. I thought that I'd done this before but, for the life of me, I can't figure it out. Thanks in advance.
I have the following formula perform a data sort. {=(ADDRESS(MIN(IF(E2:E483=G2,ROW(D2483))),COLUMN(D2483),4))} How do I convert the resulting cell address to the cell value. I thought that I'd done this before but, for the life of me, I can't figure it out. Thanks in advance.
H hopback Mar 16, 2006 #3 couldn't figure it out so I rewrote the formula. {=MAX(($E$2:$E$483=H2)*($F$2:$F$483))} cleaner this way
couldn't figure it out so I rewrote the formula. {=MAX(($E$2:$E$483=H2)*($F$2:$F$483))} cleaner this way
483))),COLUMN(D2