# Extract date from matrix to list according to criteria

#### hpernaf

##### New Member
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.

Also posted here Extract data from matrix to list according to criteria

Last edited by a moderator:

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Fluff

##### MrExcel MVP, Moderator

Cell Formulas
RangeFormula
A2:A14A2=IFERROR(INDEX(Plan1!\$A\$3:\$A\$12,AGGREGATE(15,6,(ROW(Plan1!\$A\$3:\$A\$12)-ROW(Plan1!\$A\$3)+1)/(Plan1!\$B\$3:\$AE\$12="x"),ROWS(A\$2:A2))),"")
B2:B14B2=IFERROR(Plan1!\$A\$1+INDEX(Plan1!\$B\$2:\$AE\$2,AGGREGATE(15,6,(COLUMN(Plan1!\$B\$2:\$AE\$2)-COLUMN(Plan1!\$B\$2)+1)/(INDEX(Plan1!\$B\$3:\$AE\$12,MATCH(A2,Plan1!\$A\$3:\$A\$12,0),0)="x"),COUNTIFS(A\$2:A2,A2)))-1,"")

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
5
Views
426
Replies
5
Views
761
Replies
1
Views
69
Replies
1
Views
192
Replies
0
Views
88

1,126,986
Messages
5,621,991
Members
415,872
Latest member
ReignEternal

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back