most recent date

  1. T

    Formula for transferring most recent data from cells

    Bit of a novice, so would appreciate some help with this. I am trying to find a way to use a formula to extract data from one simple form to another. However, I'm getting stuck with constructing it. The first form looks like this: WEEKLY INSPECTION <tbody> DATE ROOM NUMBER WORK REQUIRED WORK...
    • Tasky
    • Thread
    • if formula match and index most recent date
    • Replies: 2
    • Forum: Excel Questions
  2. J

    Sum most recent value by reference criteria

    Hi, I have a set of data as below, with values for individual references for each quarter. These may be updated on a weekly basis. <tbody> Data Ref Date Q1 Q2 Q3 L1 01/01/2015 1 1 1 L2 01/01/2015 2 2 2 L3 01/01/2015 3 3 3 L4 01/01/2015 4 4 4 L5 01/01/2015 5 5 5 L6 01/01/2015...
  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...
  4. G

    VBA code to find most recent date in column A that match a value in column B

    I'm trying to find VBA code to be able to set the value in column U to "TRUE" when the Date in column A is the "most recent" based on a value in column B. So what I have is a list of numbers in column B and a date in column A against each number. The numbers in column B may be repeated once or...

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