earliest

Hi Guys, Lets say you have 20 Dates, 10 for each year: 2018, 2019. You also have two ID's. I'm trying to find the earliest date in 2018 and the earliest date in 2019, in which each ID appear. MIN, MAX wont work, as the dates can be in the future or in the past. The data also isn't sorted and...

Can anyone provide me with a formula to obtain the "Earliest Response Time" for each row when "Response A" or "Response B" = "Responded". If both do not match then the earliest response time should remain blank as per the entries shown in the table below: Name Response A Date A...

I have been working on this for about a day now, searched everywhere and cannot seem to find a solution I need to return the column header of the earliest entry which meets a particular Phase in column A, i.e. for Phase 3 I would expect formula to return May-19. Excel...

Hi, I have raw data arranged as follows: Column A: Product Codes Column B: Month End Dates There are dozens of different product codes in column A and each is associated with up to 10 month-end dates. Can someone please suggest a formula that will put in cell C1 the earliest date in...

I am having trouble getting this formula to work properly. =INDEX(SetUp!$C$2:$Z$16,MATCH($O50,SetUp!$A$2:$A$16,0),MATCH(P$1,SetUp!$C$1:$Z$1,0)) On the sheet the formula is in I have data from row P2:DV2. P2 is a formula =MIN('Scheduling Setup'!C2:F2)) to get the earliest time available...

Hello I have a spreadsheet COL A - contains a year COL B - persons name COL C - formula counting the number of years for the person named in COL B What I would like is to enter in COL D - the earliest year for the person COL E - the latest year for the person There can be upto 18 rows for...

Hi All, I need some help to calculate earliest retirement date. I have DOB (A1) and Date of Hire (B1) earliest retirement requires age of 60 plus 10 years service. Would like to have a date return from the formula. Thank you all!

Hi everyone, Can't seem to make this work... I have a table like this: <colgroup><col><col><col></colgroup><tbody> Vendor invoice nr invoice date Alfa 1 11-10-2018 Beta 23 10-02-2017 Beta 24 01-03-2015 Delta 58 06-04-2016 Delta 59 07-04-2017 Delta 60 08-04-2018 Gama 70...

I have seen references here to formulas like this =MIN(IF(A1:A3="",0,A1:A3)) What I'm doing is this =MIN(G2,I2) I want the minimum value (earliest date/time) from one cell or the other which are in date/time (mm/dd/yyyy hh:mm) format. The only issue is, it represents 2 blank cells as...

Hi Everyone, I am having a minor melt down with a formula or lack of. I have a rather large table which has a whole load of times in. I have added a column to the end and i want it to show the earliest time but ignore 00:00. For some reason every example i have found online does not work. And...

New to forum! Hello and thanks! I'm trying put a column in a table of donations that indicates whether or not its the earliest donation ("FirstGift") from that individual donor. Or, better yet, have a column return whatever place each gift is ("GiftNumber") with 1 being the first/earliest...

So I'm not sure how to solve my problem or what formula would be best: I am copying a scanned image of a schedule from PDF, that I have recognized text on, to my excel product. I paste the data into certain cells and it should auto-calculate things for me. My issue comes from tracking the...

I'm stumped. I'm attempting to return the earliest date that an expense with costcode 520 occurred in cell F2 (answer is 6/1/2017). Any suggestions?

I've read the other posts about finding the earliest date in a row. However, in my case, I have 20 columns of dates in the row. The first column does not necessarily contain the earliest date. Once there is no legitimate date for a column, the remaining columns are filled with 1/0/1900...

Hello All, I've been struggling with an issue and was wondering if anyone might lend some guidance. 3 tables exist in my data model... I. Store, ProductCategory II. Store III. Store, UnitSales, DollarSales A many to many relationship exists between tables i & iii via ii. I am...

Morning, I've been trying to figure this out for days now and I'm getting nowhere fast and no matter how much googling I do I just can't find something that does what I need. I have a very basic worksheet, albeit with 200 rows, that includes names and the dates that their contracts are due to...