Ah, Summer is coming & I need help with camp attendances

  • Thread starter Thread starter Mustanganna
  • Start date Start date
M

Mustanganna

OK I have 2 spreadsheets. They are very simple and so is what I want t
do...I just can't seem to figure it out!

*SS 1* shows which weeks a child will be attending a daycamp program.
"N" means they are not attending. 4964

*SS 2* needs to show a list of the children that are attending durin
that week (so all the names on SS 1 that do not have an N in tha
week's cell).4963

I have tried a combination of IF THEN formulas but nothing seems t
work. This might seem stupid because cut + paste always works, but S
1 is the master and changes on that need to be automatically updated t
SS 2. Plus I have 45 of these to do, so I would rather not have to d
it all manually.

THANKS in advance for any assistance you might be able to lend!

+-------------------------------------------------------------------
|Filename: ss1.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4964
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for attendance record 8
Help with an array and SUMPRODUCT 3
I need help with setting up an attendance register 7
Missing attendance records (Wizard won't help) 3
I need a formula 1
Design to track attendance in multiple series 1
membership & attendance table structure 2
Help needed with formulas 9

Back
Top