C
Colin
I've been working on a weekly totals sheet dealing with appointment
information that is linked to a database. at the bottom of my totals sheet
there is a detailed section for appointments rescheduled for that week.
the data looks a little like this:
P Q R
10 Resched.
11 Monday 0
12 Tuesday 6
13 etc 0
14 etc 0
15 etc 0
16 TOTAL 6
All of the appointment data (date,id #, reason) is hidden in columns af:ah
the bottom section/table needs to show the date, id #, and reason for each
rescheduled appointment. I know I need to use the "index" formula, but if
there's more than one reschedule per day (see example), that's where I get
stuck. Any suggestions?
information that is linked to a database. at the bottom of my totals sheet
there is a detailed section for appointments rescheduled for that week.
the data looks a little like this:
P Q R
10 Resched.
11 Monday 0
12 Tuesday 6
13 etc 0
14 etc 0
15 etc 0
16 TOTAL 6
All of the appointment data (date,id #, reason) is hidden in columns af:ah
the bottom section/table needs to show the date, id #, and reason for each
rescheduled appointment. I know I need to use the "index" formula, but if
there's more than one reschedule per day (see example), that's where I get
stuck. Any suggestions?