# How to make excel learn formula reference pattern

#### Shreya

##### New Member

Hello,

I am using the spreedsheet posted above to get the latest date from the 'In Column' for each book/ number i.e lets say book 1 in above case was lent out 3 times and returned las on 11-28-20, I want to see the last day when it was returned. The formula I am using in the spreedsheet is:

The issue I am facing is that I have about 220 books and excel is not learning the pattern of my formula AB,AA,BB then CD,CC,DD then EF,EE,FF. Is it possible to teach excel the pattern so that I don't have to type that in 200 times? Your ideas on this is highly appreciated.

Thank you

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### Shreya

##### New Member
just to explain a little bit further. The formulas I am typing in are: =IF(MAX(Sheet1!A:B)=MAX(Sheet1!A:A),"",MAX(Sheet1!B:B)) for 1, =IF(MAX(Sheet1!C:D)=MAX(Sheet1!C:C),"",MAX(Sheet1!D:D)) for 2, =IF(MAX(Sheet1!E:F)=MAX(Sheet1!E:E),"",MAX(Sheet1!F:F))

Replies
21
Views
865
Replies
6
Views
189
Replies
3
Views
132
Replies
3
Views
67
Replies
4
Views
287

1,126,986
Messages
5,621,993
Members
415,873
Latest member
fuulhouse

### 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