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.

You could add a column to your table, and enter a formula to count the
Ys in each row. For example, in cell N2, enter:

=COUNTIF(B2:M2,"Y")

Copy the formula down to the last row of data, then sort by the new column.

mlk wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html