Sorting Problem

[riderfan]

I am trying to use excel to do standings for a football pool. What I'
like to sort is everyones standings. The problem lies in the fact tha
the standings list draws from different cells. So it looks like this:
A B
Bob =d5
Sam =e5
Brian =g10
Kevin =g15
Phil = f10

And I'm trying to sort by Column B. The cells d5 e5 g10 etc are th
team totals that have been added up using another formula. But I'
just trying to sort a type of "Leaderboard" list. Is there any way t
do this? As soon as it sorts it I'm getting #ref errors as the cel
values have changed with the sort. Thank you. Jor

 

[Rita Palazzi]

Use $ to keep references the same i.e =$D$5. This will always reference
same column and row. If you need to drag for some reason:
$D5 >> column stays same, but row will change as you drag up and down

D$5 >> row stays same, but column will change as you drag right to
left or left to right

$D$5 >> will always reference cell at D5

Hope this helps
Rita