C
caleb
I currently have a formula that ranks a cell within the column it is
in. However i was wondering if there was a way to rank a cell in a
different column within this column. For instance, can i only rank B12
within B4:B44 or can i rank C12 withink B4:B44.
Here is my formula as is. would like to rank z28 instead of i28....any
ideas. if i just make the change i get a #NA
=IF($I28>0,RANK($I28,$I$4:$I$39,0)&" of "&COUNTIF(($I$4:$I$39),
(">0")),"N/A")
any help would be greatly appreciated.
in. However i was wondering if there was a way to rank a cell in a
different column within this column. For instance, can i only rank B12
within B4:B44 or can i rank C12 withink B4:B44.
Here is my formula as is. would like to rank z28 instead of i28....any
ideas. if i just make the change i get a #NA
=IF($I28>0,RANK($I28,$I$4:$I$39,0)&" of "&COUNTIF(($I$4:$I$39),
(">0")),"N/A")
any help would be greatly appreciated.