#### CAW

##### Board Regular

- Joined
- Jul 1, 2004

- Messages
- 173

Any ideas would be greatly appreciated. Here we go:

Column A -- Independent Number on Each Candy - there at 15 candies numbered 1 - 15 all with different Candy Sizes

Column B -- Size of Candy - also independent - measured after the candies are numbered

Column C -- Candies ranked by size - 1 is biggest, 15 is smallest - dependent on Candy Size ( he’s using =RANK(B3,$B$3:$B$17) )

Column D -- Independent Childrens' Names

Column E -- The rank, by Candy Size, this child should get - the nicest kid gets the largest candy (rank = 1 but not Candy Number) and Mike is nicest. Amy is meanest so she gets rank = 15 - again this is independent

Column F -- This is what I (my supervisor) cannot figure out how to do in Excel. I can figure it out in my head - Mike gets candy number 5, Tom gets candy number 11, Deb gets candy number 10, etc. Can something be used here where Excel will figure it out anytime any new numbers get entered into this chart?

Column G -- I know how to do this, it tells me the size of the candy to give the kid but not the Candy Number ( he’s using =LARGE($B$3:$B$17,E3 )

We’re using Excel 2003 here, btw.

Again, thanks a lot.