Forum Discussion
Need help on a formula if it's possible
I have worksheets setup by week, in one workbook per month. Each worksheet has identical schedules listed daily with the dates on the top. By each item in the schedule I have put an 0 or an X indicating whether that item was attended for that day. I need to set up a summary page with the dates that contain an X. See below:
Worksheets by week and then summary worksheet for entire month:
Hi,
the only thing came to my mind is IF as below - but it's a bit time consuming!
is this OK for you?
Yes I was thinking the same, but is there a way to summarize and list the dates on one worksheet for the entire month?
you can use a Pivot table as below
but you need to rearrange you table
- I don't know if the table below is OK for you?
