CAW
Board Regular
- Joined
- Jul 1, 2004
- Messages
- 173
My supervisor has asked me to do something with an Excel spreadsheet he has that shows part numbers and ranking based on certain info. Since I have no idea what he’s really looking for, I asked him to explain it in as simple of a format as possible. I know understand what he’s looking for, but I have no idea how to do it in Excel, or if it’s even possible in Excel.
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.
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.