I have a non contiguous range and I want to find the cell address of the max value. I used =Max(UsedInv) to find the maximum value. But I cannot find out how to get the address of that cell.

Chuck