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.
couldn't figure it out so I rewrote the formula. {=MAX(($E$2:$E$483=H2)*($F$2:$F$483))} cleaner this way