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 indic...
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?
Thanks I'll try it!