Need a formula that can return the first available date in Column A based on the Model listing in Column F. The date must not have a Product ID in Column B, but the Product Type in Column C needs to match the first Model from Column F.
In simple terms I want to know the next available start date from the top down that I can start a specific Model Type in column F. If a Product is already slotted to a specific start date then do not return that date.
Thank you for all the support!
Last edited by jclaborn; 04-22-2020 at 10:45 PM.
does this work
=INDEX(A:A,MATCH(1,INDEX((F2=C:C)*(""=B:B),0,1),0))
will you have dates before today() in the list
so is a date after today() needed
=INDEX(A:A,MATCH(1,INDEX((F5=C:C)*(0=B:B)*(TODAY()<A:A),0,1),0))
Last edited by etaf; 04-16-2020 at 12:45 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi jcl,
No formulas needed. Just a simple pivot table where you filter the ID for blanks and pick minimum date. See the attached
Next Available Date Pivot Table Blank filter.xlsx
You will need to convert those Text Dates to real dates.... To do that use Paste Special of a cell with zero in it to ADD ONLY across all your text dates.
https://office-watch.com/2018/text-t...paste-special/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for the reply! Your first formula worked with my test sheet. But your correct with with your second statement. I do have dates on my schedule that are from last year etc.. When I try and use your 2nd formula I get the #NA error.Originally Posted by etaf
can you load an example
Hey etaf,
I attach files using the picture icon so it takes less room. In my post above, click on the blue link of "Next Available Date Pivot Table Blank filter.xlxs" and it will open my example.
Sorry if that is confusing..
Sorry, I should have said who that was refering to - I was asking OP for examples where the formula did not work
I'm sure a pivot table is a better option
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks