What is the easiest formula to use to use the the last cell with data in a column?

C12HD

I have data coming in from a form..... which creates a new row at the bottom of all the data in the sheet. I need a formula that will continuously pull form the last cell with data. Overall, I just need the last cell in the column to be divided by another to get a percentage, but I do not want to have to go in every month and update the cell in the formula. Example below shows that in row 8 the sales numbers was $28,000. Row two shows the goal was $30,000. Row 5 is where the formula is to say what percentage that was of the goal. Simple..... but I just need it to pull from the newest numbers in the "sales number" column.... I need this to be current so it needs to always be pulling the last amount that was submitted by the Form (which automatically goes to the bottom row).

KPH

Hi

If you add an auto number column to your sheet, every row that is added will be given a number. You can then use the MAX of that number to find the last row in your sheet using an INDEX MATCH formula. I prefer using auto number to using the date/time as date/time fails if two rows are submitted within the same minute.

To ensure you always capture the very last row in the sheet is it best to reference a full column ([Sales numbers]:[Sales numbers]) rather than referencing a specific range ([Sales numbers]5:[Sales numbers]50). This does mean you will need to offset your calculation column so it is not within the same column as your sales data (as this would create a circular reference).

Here is an example:

The formula in the yellow box is:

=INDEX([Sales numbers]:[Sales numbers], MATCH(MAX(Row:Row), Row:Row, 0))

You can set up an auto number column by selecting the auto number column type:

I hope this helps.