Hi everyone!
I'm creating a monthly schedule template for scheduling customer diaries as shown below.
Basically, I will insert with an "X" the day that the client has an appointment throughout the month.
As I insert an "X" for a given customer on a certain date, I would like the customer's name and date to be automatically listed in another spreadsheet as shown below.
Does anyone have any idea how to come up with this? I tried some combinations with OFFSET, INDEX, MATCH but without success.
If anyone can help me, I'm leaving the worksheet attached.
Thanks in advance.
Also posted here Extract data from matrix to list according to criteria
I'm creating a monthly schedule template for scheduling customer diaries as shown below.
Basically, I will insert with an "X" the day that the client has an appointment throughout the month.
As I insert an "X" for a given customer on a certain date, I would like the customer's name and date to be automatically listed in another spreadsheet as shown below.
Does anyone have any idea how to come up with this? I tried some combinations with OFFSET, INDEX, MATCH but without success.
If anyone can help me, I'm leaving the worksheet attached.
Calendar.xlsx
drive.google.com
Thanks in advance.
Also posted here Extract data from matrix to list according to criteria
Last edited by a moderator: