P
pkbravo
these are my columns.
A B C
1 aa 26.9% Column c percentages are pulled fro
other
2 xx 25.1% sheets in the workbook. so th
cell refrences
3 oo 10.5% are in there. ex. 00!L58
4 nn 30.1%
now. i want to rank them from smallest to largest in another cell.
here are my formulas.
A B C
1 =small(c1:c4,1)
2 =small(c1:c4,2)
3 ..
4 ..
my problem is i cannot get the name to come into column B. vlookup
just puts a number in there. any help would be greatly appreciated.
:confused
A B C
1 aa 26.9% Column c percentages are pulled fro
other
2 xx 25.1% sheets in the workbook. so th
cell refrences
3 oo 10.5% are in there. ex. 00!L58
4 nn 30.1%
now. i want to rank them from smallest to largest in another cell.
here are my formulas.
A B C
1 =small(c1:c4,1)
2 =small(c1:c4,2)
3 ..
4 ..
my problem is i cannot get the name to come into column B. vlookup
just puts a number in there. any help would be greatly appreciated.
:confused