last occurrence

  1. S

    Search last occurence of character and return word that contains it

    I would like a formula that looks for a specific character in cell and returns the last word that contains it. Example: extract the last word (string?) from A1 that contains the "." (dot) character: A1 B1 FirstName LastName 1984 1:15.84 1:07.84 2 1:07.84
  2. E

    SEARCH FOR LAST MATCHING OCCURENCE IN Wb2, PASTE RANGE OF CELLS BACK TO Wb1

    Hi Guys, In short, I need to search for a value in column A of a sheet in another workbook and copy that block of cells back to the first workbook. The code is in Wb1. Search for a Reference number in column 'A' (only) of a specific (chosen) worksheet of Wb2. The specific worksheet name is in...
  3. R

    Excel 2003 Subract current value from value on most previous date

    Please help me find the best way, in Excel 2003, to calculate the difference between the values on the last two most recent occurrences of data. Here is a sample of the data. For example: I am looking for a formula to find the difference between Ann's End Bal on 4-Oct, and Ann's End Bal on...

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