I have a very large spreadsheet of all of our cases. The headings correspond
to the following columns:
case # = column A, client # = B, last name = C, first name = D, Social
Security# = E, location # = F, case manager # = G, case type = H, additional
case identifier (not on all cases) = I, case status = J, and next review date
= K. The basic case types that we have are coded either "F", "M", or "A".
All clients should have an item for each heading (except for the additional
case identifier and Social Security#). So, for example, Joe Blow could have
an F case and an M case, Joey Blow could have just an M case, etc. The way
the list reads is that if Joe Blow has two cases, on one line is listed his
information across headings for the F case, and just below that is his
information again, but for the M case; Joey Blow would have his case
information on just one line, and likewise for the rest of the clients.

I need to find a way to sort all single cases (those with just an F, M, or A
case and nothing else) and list them on a different worksheet, and sort all
combination cases (F + M + A, F + M, F + A, M + A) and list them on a
different worksheet.

I am not sure where to start. Can you please help me find an efficient way
to do this?
Thanks.

there is probably a more efficient way, but you could insert a column before
column a and enter the following:

=countif(b:b,b2)

this will count how many times your client number appears.

you can then remove all the rows that have a 1 in this new column as single
cases. then sort the remainder by your count column, then by client number,
then by case type

"Bradly" wrote:

I have a very large spreadsheet of all of our cases. The headings correspond
to the following columns:
case # = column A, client # = B, last name = C, first name = D, Social
Security# = E, location # = F, case manager # = G, case type = H, additional
case identifier (not on all cases) = I, case status = J, and next review date
= K. The basic case types that we have are coded either "F", "M", or "A".
All clients should have an item for each heading (except for the additional
case identifier and Social Security#). So, for example, Joe Blow could have
an F case and an M case, Joey Blow could have just an M case, etc. The way
the list reads is that if Joe Blow has two cases, on one line is listed his
information across headings for the F case, and just below that is his
information again, but for the M case; Joey Blow would have his case
information on just one line, and likewise for the rest of the clients.

I need to find a way to sort all single cases (those with just an F, M, or A
case and nothing else) and list them on a different worksheet, and sort all
combination cases (F + M + A, F + M, F + A, M + A) and list them on a
different worksheet.

I am not sure where to start. Can you please help me find an efficient way
to do this?
Thanks.

actually use = countif(c:c,c2)

(forgot to account for the shift in your columns after the inserted column)

"joemeshuggah" wrote:



there is probably a more efficient way, but you could insert a column before
column a and enter the following:

=countif(b:b,b2)

this will count how many times your client number appears.

you can then remove all the rows that have a 1 in this new column as single
cases. then sort the remainder by your count column, then by client number,
then by case type

"Bradly" wrote:

I have a very large spreadsheet of all of our cases. The headings correspond
to the following columns:
case # = column A, client # = B, last name = C, first name = D, Social
Security# = E, location # = F, case manager # = G, case type = H, additional
case identifier (not on all cases) = I, case status = J, and next review date
= K. The basic case types that we have are coded either "F", "M", or "A".
All clients should have an item for each heading (except for the additional
case identifier and Social Security#). So, for example, Joe Blow could have
an F case and an M case, Joey Blow could have just an M case, etc. The way
the list reads is that if Joe Blow has two cases, on one line is listed his
information across headings for the F case, and just below that is his
information again, but for the M case; Joey Blow would have his case
information on just one line, and likewise for the rest of the clients.

I need to find a way to sort all single cases (those with just an F, M, or A
case and nothing else) and list them on a different worksheet, and sort all
combination cases (F + M + A, F + M, F + A, M + A) and list them on a
different worksheet.

I am not sure where to start. Can you please help me find an efficient way
to do this?
Thanks.