Show the most recent entry

[themightyreds]

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

 

[Domenic]

Try...

B2, copied across:

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

 

[themightyreds]

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]

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

 

[Domenic]

Try...

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

 

[themightyreds]

simple as that eh!