View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Ashley
 
Posts: n/a
Default HOW DO I GET TEXT TO COME UP BESIDE FORMULA

A2:A150 are NAMES, B2;E150 contain values, F2:F150 are the sum of the vaues
for each name. On another worksheet I used a LARGE function to sort the sum
into decending order, but I can't get the names to enter in the next cell?

"CLR" wrote:

Please specify the ranges of cells that contain your NAMES, and which contain
your NUMBERS.............

Vaya con Dios,
Chuck, CABGx3



"Ashley" wrote:

I have a list of names and an array of numbers to their names. I have sumed
the arrays of each name and placed them in accending order using LARGE()
function. I need the names to come up in the box beside the accending LARGE
function. So I can see who came 1st, 2nd, 3rd....etc