View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Populating a grid

I have about 60 managers and each one has two rankings, a 1-4 and a
I-IV (example: manager X: 2, III; manager y: 3, IV.). I then want to
create a function that will populate a table like below:
1 2 3 4
I____|___|___|___|
II___ |___|___|___|
III___|_X |___|___|
IV__ |___|_Y_|___|

I can't figure out the best most automated way to do this....any
suggestions?