sort out attended list n unattended sheet

August 12, 2011 at 03:04:07
Specs: Windows 7
I have a masterlist of registration and 3 sheets of Attendee list, I need to sort out between attended and unattended list of sheets.

eg: collumn caption: Name, Program, contact

there is a master list sheet and attendee list sheet.
How do I sort out in masterlist between attended and not attended.

Please help me...
Thank you in advance

See More: sort out attended list n unattended sheet

Report •

August 12, 2011 at 07:27:20
You could try VLOOKUP.

My example uses the same sheet just so I don't have to deal with sheet names in the formula.

Master List:

      A         B        C        D
1  Reg Name  Program  Contact
2    Bob       P1       C1   See formula below
3    Mary      P2       C2
4    Steve     P3       C3

Attendee List:

6  Att Name  Program  Contact
7    Bob       P1       C1   
8    Steve     P3       C3

Put this formula in D2 and drag it down to the bottom of your Master List. You should see Attended for Bob and Steve.

=IF(NOT(ISNA(VLOOKUP(A2,$A$7:$A$8,1,0))), "Attended", "")

You can then do a Ctrl-c...Edit...PasteSpecial...Values on Column D to eliminate the formula and leave the text string Attended in the cells. Sort on that column and you'll have all of the attendees sorted together.

Since you need to do this for 3 sheets, you can either use three columns, one for each sheet or Nest 3 IF's together to check each sheet one by one.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question