last value in column

  1. G

    Return First and Last Value in a Subtotal Grouping

    Team, first time user here, I've spent days looking for a solution to this, but I think I'm close but I'm simply running out of time to turn this project in. I am looking for a VBA code that will allow me to auto-populate the first value on the first empty cell of column A & the last value on...
  2. N

    Formula using last cells in two different columns

    Hi, I am making a Macro which will have different last rows every time I will be using it. I have been able to write the macro so that column D and E sum in the last row +1. Now I need to write a simple formula in column F (LastRow+1), using the values in the last rows of column D and E. If...
  3. J

    Find Last value in column *regardless* of number, text, or number-as-text?

    Hi all, I have searched far and wide, and can't find a good formula (not VBA code) to accomplish this. I've used the below, for example in Column E, the actual data starts in row 4, so I can't use the full E:E syntax...
  4. P

    Require a function to return a last non zero value in a column

    <tbody> Formula using LOOKUP function is not working for values generated from calculations in a column. I need to find the last non zero value. I have used the formula =LOOKUP(9.99E+307,1/(C9:C208<>0),C9:C208) the column C has values that are calculated based on other cells in the sheet...
  5. C

    Help - code to automatically indicate the value

    Hi everyone! I need a code who identify the last value of column D of worksheet "Data" and put this value + 1 in worksheet "Form" cell E3. So the cell E3 of worksheet "Form" must have automatically the last value of column D of worksheet "Data" adding + 1 to this value. If no values in column D...
  6. S

    Find last value in a column and insert in a cell on another sheet?

    What would be the formula to find the last value in column "c" on sheet 1 and insert it in a cell on sheet 2? I am using Excel 2007. Thank you for your help. Sophie813
  7. M

    Last value in column

    I have a column of values (Buy or Sell). There are blanks between some of the values. I need to know the last value in the column. I have Googled it, but I don't understand the explanations. Any help is appreciated, Manassasralph

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top