I have been assigned a task at work to create a spreadsheet, similar to a
survey I guess, where I will have a list of categories in the left column and
beside each category I will have 5 check boxes to gauge the strength of the
response from, say, critical down to not important. I dont want them to be
able to check more than one box at a time per category. I have checked out
the treads on grouping but get a little confused about how to go about it. I
would then like to be able to sort the results by importance. I am using
Excel 2003 and I do not have InfoPath at work or at home.