CODEWITHSUNDEEP
excelexcel-formula
EnglishTeacherEric
EnglishTeacherEric

Reputation: 259

Returning most recent value from a row in Excel

I finished standardizing over 100,000 entries from national time-series data in a research project but there's one last step: many countries do not report data for every year. I want to fill those gaps with the entry from the most recent year.

Each row of each sheet represents one country from 1995 to 2015, left to right. Everything will be migrated to a new worksheet. Is there a way to carry the most recent value? This must be done without VBA for technical reasons.

Upvotes: 0

Views: 354

Answers (1)

Sumit Jain
Sumit Jain

Reputation: 377

You can use normal if function to get the outputenter image description here

Green colored cell shows the desired output

Upvotes: 2

Related Questions