Automatic Sorting of Top Ten values in a table

[Guest]

Hi,

I have a two column table of names and related values e.g. Fund1 6%, Fund2
11% etc. The table references another table so the cells have references not
actual values. When i try to set up a list and sort by top 10 it doesn't
work. when i copy and paste values then it will sort. But i would like to
automate the process - so when the parent table changes then the new top ten
values are automatically calculated...can anyone help? (excel 2003)

Thanks!!!

 

[Guest]

two possible solutions are
using indirect() function
=indirect("A3") will always reference A3 no matter where it is moved in the
sheet


set of a helper column with the rank() function
set up a special top ten table referencing the rank value to select the
information

 

[Guest]

Thanks for the tip BJ! I ranked the values then used a vlookup...