# Show the most recent entry

#### themightyreds

##### Board Regular
I have Dates running from A3 - A367 (the whole year) In B1-D1 I have the names Mick, Mike and Michael. Mick, Mike and Michael travel from city to city and each time they move I place the city name in the corresponding date cell. I wish for their current location to be shown in B2-D2.

Can you help??

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### Domenic

##### MrExcel MVP
Try...

B2, copied across:

=LOOKUP(REPT("z",255),B3:B367)

#### themightyreds

##### Board Regular
Try...

B2, copied across:

=LOOKUP(REPT("z",255),B3:B367)

I have absolutely no idea how that works but work is does!!

Many Many Thanks for your time

Matt

#### themightyreds

##### Board Regular
Is it possible to show the date of the last movement in another cell?

#### Domenic

##### MrExcel MVP
Try...

=LOOKUP(REPT("z",255),B3:B367,\$A\$3:\$A\$367)

#### themightyreds

##### Board Regular
simple as that eh!

Replies
8
Views
195
Replies
1
Views
493
Replies
10
Views
485
Replies
2
Views
163
Replies
1
Views
247

1,132,890
Messages
5,655,816
Members
418,238
Latest member
LizzyG

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