earliest date

Hi I have a numbers of rows with dates, some of the cells are blank in these rows My manager asked to to find the earliest date in each row (used formula =SMALL(A1:D7,1) this returned me the earliest date from the row I need to paste this result (earliest date) into all the cells that have a...

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...

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...

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...

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...

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)...

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...

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 =...