Solved: Chose last of identical data from a column

[realitybend]

This thread was originally here (http://www.vbaexpress.com/forum/showthread.php?t=20777). Then I found out it wasn't completely solved, after all.

Anyway, grichey (http://vbaexpress.com/forum/member.php?u=12906) showed me a solution using VLOOKUP. However, I have cases where there are two copies of the data in column A, and in that case, I need to copy the data corresponding to the last of the identical values.

Any solutions?

Thanks.

[grichey]

Post and Example workbook

[realitybend]

Here's that example file.

[realitybend]

Sorry, here it is instead, attatched this time.

[mikerickson]

This Array formula should work
=INDEX(AB:AB,MAX(--(A:A=100)*ROW(A:A)),1)


Array formulas are confirmed with Ctrl-Shift-Enter (Cmd+Return for Mac)