Thread: grouping data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Hilton
 
Posts: n/a
Default grouping data

I have a worksheet with a list of names in one column and a group of
numerical scores in another column.

On a seperate worksheet, I need, a 4 wide x 2 high grid, each grid is
filled with names from the first worksheet, for those that meet a specific
range of scores. Each "grid" is say one cell wide by X cells high with one
person per cell. The ranges are such that no person would meet more that one
range.

If this can be done via worksheet functions great.

Thanks

Carl