In my Excel sheet, I want Excel to automatically fill in a column value based on the value from the same column in previous rows.
Specifically, consider the following example data:
The value in
column C of the current row should be automatically filled in with the value from
column C in a previous row where the
column A values match.
Using the example data above, where the current row is
row 3, then
C3 should be populated with the value from
C1 (25) because
- I may overwrite the formula in some rows;
- There may be multiple matches;
- In the case of multiple matches, the match with the highest row number should be returned;
Is there a way to configure Excel such that it auto-fills column
C based on matching the value in column
A to prior rows?