I am a teacher tracking missed spelling words by using an Excel SS table with
student names across the top and the spelling words along the side. Each cell
within the table is either blank or contains a number designating the total
times the student has missed each word.

How can I generate personalized lists of missed words for each
student and indicate the number of times each word was incorrectly spelled?

My first thought was to somehow use Access to manipulate the file info, but
a person in that help group said it would take several days work of work to
get a "normalized" datebase out of the Excel file.

Is there a way to do a lookup to see if the cell contains data and if yes,
put the word and number in the cell into a list that also contains other
words for the same name?

Thanks in advance for any suggestions.