I am working in Excel 2000 and I have a file that has approximately 1000 rows
of data. I have 13 columns that reflect different months. Some columns have
a Y in them which means work was done in these months but there are other
columns that do not have a Y. I have done a sort so that I have all the ones
that have a Y under all 13 columns. Unluckily, after that there is no way to
see if there is someone that may be missing only one month unless you go
through all 1000 rows. Is there any way that this can be done to see if
someone is missing one month, 2 months, etc.