View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edbarunning
 
Posts: n/a
Default Selectig a cell based on and <

For each runner I need o plac ethem into a group based on thier time in a
mile. For instance a runner with a time of 5:23 would be placed in group 1,
all runners who ran 5:00 and < 5:30.

I have 30 groups and a few hundred runers to deal with. Ideally what I want
to do is select their name, type in their time and have the group indentifier
appear in an adjacent cell.

Thanks
--
EDba