I need help writing an Excel formula.
(1) Cells D11146 list numbers that are in ascending order.
(2) Cells G11:G145 also list numbers, but not sorted in any particular order.
(3) I need a formula that for MAX(D11146), with D146 = MAX, will give me the number in cell G145 (NOT in cell G146, which is blank). Thanks. Robert