Pick the most recent value

[salazachou]

Hi everyone I am trying to to pick or take a value that is available for several years, and I want the most recent value.

The years are organized in columns and the items in rows. I wanto to calculate the column "MOST RECENT PRICE"

ITEM	PRICE YEAR 2020	PRICE YEAR 2021	PRICE YEAR 2022	MOST RECENT PRICE	COMMENT
A	34	23	43	43	<- 2022 price is the last one
B	23			23	<- 2020 price is the last one
C	53	43		43	<- 2021 price is the last one
D	34			34	<- 2020 price is the last one
E			85	85	<- 2022 price is the last one

Regards

[ExceLogan]

hi there, I propose this possible solution:

Please Login or Register  to view this content.

Hope was usefull.

[CARACALLA]

E2=IFERROR(LOOKUP(2,1/(B2:D2<>""),B2:D2),"")

Copy down

[salazachou]

Thank you I tried and worked, !!!

[salazachou]

Thank I tried this one as well and worked.