How to select a last added value from a column
Would love to get feedback on how to get a "Last added value" of a particular item. I have a list of items which keeps adding in the sheet as new rows. I need a formula that looks at a column to pull the latest value/entry made. What I want is a formula that updates automatically as I populate new rows.
Below is a screenshot that shows the columns I am working with. The value of the column “Closing Stock” I am trying to populate in a new row as “Opening Stock”. The goal is to capture the most recent entry of “Closing Stock” column based on the “Product Name” column.