Hi Guys,
I'm having trouble on getting the exact formula on this one.
I need to get the Stages (the cell with colors) by the cut-off dates.
For example.
Screenshot 2016-04-28 at 08.59.34.png
Hi Guys,
I'm having trouble on getting the exact formula on this one.
I need to get the Stages (the cell with colors) by the cut-off dates.
For example.
Screenshot 2016-04-28 at 08.59.34.png
Last edited by jrahm23; 04-27-2016 at 09:25 PM.
Can you upload a small sample Excel workbook? Many of us cannot see images and it gives us live data to work with if you do.
Thanks,
Dave
Dave
Attached the file. Sorry.
Last edited by jrahm23; 04-27-2016 at 09:25 PM.
Since dates in each of the columns are the same it is difficult to understand what you want.
Could you re-upload with desired results hand typed in? Perhaps we could better understand what you wish to do.
Hold on.
Perhaps I do understand.
Try this formula in K2:K4then copy that range and paste to columns Q and S.Formula:Please Login or Register to view this content.
Hi Flame, Thanks for answering.
Here's a clearer version.
From column I to T. I need to fill the stages (Column B to G) of every PO base on the dates from column B to G.
Screenshot 2016-04-28 at 10.18.59.png
Essentially the same formula as before ... copied / pasted to the rest of the columns.
In L2Formula:Please Login or Register to view this content.
Workbook is attached with working worksheet copy to confirm the header matches.
Hi Dave,
OP wants the names of columns not dates, I think
Thanks for your answer Flame.
What I need to get on the (column I to T) is the Stages (B1 to G1)
For Example.
PO 001 the Invoice Received Date is 1/25/2016 then Invoice Received Date (text) would be print on 28-Jan (Column L) but because the next stages are on the same cut-off date then will get the latest stage of that cut-off which is Date Scanned.
OK. Change the first argument of INDEX to point to the header row. In L2Formula:Please Login or Register to view this content.
Thanks for answering Flame.
I want to clarify that the "-" is also included on the formula.
In that case use this in I2 fill down and across.Formula:Please Login or Register to view this content.
This depends upon the cell to the left of the first date in I1 (ie H1) to have no numeric value greater than the dates in respective rows of B2:G6. Ie a blank H1 as you currently have it works.
Please let us know how this does with your 'live' data.
Last edited by FlameRetired; 04-28-2016 at 05:33 PM.
Thank you so much Flame. This is good and I already got the needed data.
You are welcome. Thank you for the feedback and the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks