Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index formula and VLookup w/ Multiple Values | Excel Worksheet Functions | |||
Multiple values (INDEX?) | Excel Worksheet Functions | |||
Index function using multiple values in one cell | Excel Worksheet Functions | |||
match/index using multiple values | Excel Worksheet Functions | |||
return multiple corresponding values using INDEX | Excel Worksheet Functions |