unduplicated list

B

BuddyGSD

New member
Joined
Oct 24, 2016
Messages
6
Reaction score
0
Points
0
Hello everyone,

I'm currently working on a spreadsheet for the next 5 months where we are going to provide assistances to individuals.

I would like to for one page to list all the families from all the different months and only list the unduplicated ones by itself. I have attached an excel example.

(what I'm looking for) For the month of April we assisted 5 families but in May we only had one new client (Test Six). What I would like is, how can I make excel go down each page for the next 5 months and gather this information, see the same family may come multiple times, I just need a list of the families unduplicated.

Thanks.
 

Attachments

  • Undup Clients for agency.xlsx
    14.3 KB · Views: 17
See the instructions on the worksheet. Your project is already established to do the filtering you require. Just a few more steps to see what you want.
 

Attachments

  • Undup Clients for agency.xlsx
    16.4 KB · Views: 12
Is there a way for excel to gather the names of the families from the month of April and May to appear on the Undup Clients tab then?
 
If you also include the "Check Run Date" column in the table as well, that will provide a means of selecting which month.

Code: 
[B]Excel 2007 32 bit[/B]
[SIZE=3][TABLE="class: head"]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]1[/B][/RIGHT]
[/TD]
[TD="bgcolor: #D8D8D8"][CENTER]Check Run Date [/CENTER]
[/TD]
[TD][CENTER]Last Name[/CENTER]
[/TD]
[TD][CENTER]First Name[/CENTER]
[/TD]
[TD][CENTER]Case Number[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]2[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]One[/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]1[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]3[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Two [/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]2[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]4[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Three[/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]3[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]5[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Four[/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]4[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]6[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Five [/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]5[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]7[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Six[/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]6[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]8[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]One[/CENTER]
[/TD]
[TD][CENTER]Go[/CENTER]
[/TD]
[TD][CENTER]1[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]9[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Three[/CENTER]
[/TD]
[TD][CENTER]Me[/CENTER]
[/TD]
[TD][CENTER]3[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]10[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Five [/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]5[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]11[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Seven[/CENTER]
[/TD]
[TD][CENTER]Hello[/CENTER]
[/TD]
[TD][CENTER]7[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]12[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][CENTER]Eight[/CENTER]
[/TD]
[TD][CENTER]Test[/CENTER]
[/TD]
[TD][CENTER]8[/CENTER]
[/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]13[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]14[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]15[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]16[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]17[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][RIGHT][B]18[/B][/RIGHT]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]
[/SIZE][TABLE="class: grid"]
[TR]
[TD]Sheet: [B]Undup Clients[/B][/TD]
[/TR]
[/TABLE]
 
Perhaps something like this? Hope this help



cheeers
 

Attachments

  • Undup Clients for agency-1.xlsx
    16 KB · Views: 12
You must log in or register to reply here.
Back
Top