earliest date

  1. L

    SQL Statement - Check the earliest date as per group of records - If true , return custom text in a custom column

    Guys I have the following problem. I need to identify if the date of the record is the earliest date of the group. The idea is NOT return an aggregation table, the idea is return all the records but in a custom column I want to identify if the date of the record is the earliest of the group. If...
  2. J

    Return earliest date a name appears in a column (within group of names)

    Hi All, I have a spreadsheet that contains a list of transactions. Column A contains each transaction ID, Column B contains all individuals involved in the transaction (delimited with semi-columns), column C contains the transaction dates, and Column E contains a list of all unique individuals...
  3. I

    Return the Earliest Date

    Hi, I'd really appreciate some help with, what will probably prove to be a pretty simple problem. I have a list of dates in column A, next to a list of statuses in column B, as follows.... 01/01/2012 New 01/01/2013 Open 05/05/1978 Closed 22/04/2015 New The dates are stored as...
  4. X

    3 Conditions "Earliest Date" , "Latest Date", "String"

    Hello Everyone ! I am a total noob to Excel. I've been slowly teaching myself the past 2 weeks. I have the below formula working with multiple conditions. =SUMPRODUCT((CompletionDate>=Z15)*(CompletionDate<= AA15)*Engraving) The CompletionDate is a range column of dates, Z15 is the cell with...
  5. J

    Look up item, return earliest date and item

    Hello everyone, Look up item, return earliest date and item -- Excel or Access version: Excel 2010 Computer operating system: Windows XP Sample data: "Excel WorkbookEF1DateEmail21/1/2010jonathan@gmail.com32/2/2005jonathan@gmail.com46/3/2004jonathan@gmail.comCombined " Formula(s)...
  6. O

    Find earliest data by date

    Hi all, I wonder if anyone could help me with a work related excel query I have. I have two columns of data and need to find the earliest plan date and keep only that (deleting any duplicate named plans with later dates) Please see the below example of columns I have, the result I need is...
  7. C

    Formula for identifying duplicate entries and comparing them?

    Okay, this one I can’t figure out at all. I need to identify customers in a list that have more than one entry (i.e. sold to more than once – resales/upsales etc.) and then I need excel to compare those multiple entries and identify the earliest invoice date. Any ideas? <?xml:namespace prefix =...

Watch MrExcel Video

This Week's Hot Topics

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
Top