Dynamic Assignment of a Cell Address In Formula
On Dec 13, 9:12 am, Carim wrote:
Hi,
Is your ultimate objective to get the Row Address which contains the
value appearing in cell K6 ?
Hi.
Yes, the ultimate objective would be to find the cell address which
contains the value <= to the one in cell K$6. (There could be more
than one cell with the same value and <= to the one in K6. I would
need to find the address of the cell with the biggest row number. So,
if K$6's value is "80.0%", and both cells J1234 and J5678 share the
value 80.0%, the formula would return address $J$5678 because that is
the cell with the biggest row number and with the biggest value <= to
K6.)
Once I can successfully develop this formula, I would incorporate it
in yet another formula... Should I go ahead and post this formula
too, or do you have enough info?
Thanks.
--
tb
|