LinkBack URL
About LinkBacks
Hello Friends
Please find the 2010 Version attached file <Plotting Last N dates.xlsx>.
I want to plot the date in light yellow cells for the given N Number before zeros.
thanks in advance
thilag
Hello Friends
Please find the 2010 Version attached file <Plotting Last N dates.xlsx>.
I want to plot the date in light yellow cells for the given N Number before zeros.
thanks in advance
thilag
How do you arrive at your starting date?
This will fill in the Nth number of cells...
=IF(COUNT($B$3:B3)<=$D$3,B3,"")
copied down as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello Ford
Thank for your formula.
But for the given N numbers datas are plotted from first not from last before zeros. Refer the 2 example in the attached file.
How do you arrive at your starting date?
For the given N number (May be 30 or 40) before 00-Jan-00 the set of given N number of date to be taken and plotted as is.
Hope i clarified you.
thanks
thilag
ah OK, I think I see it now, try this instead...
=IF(COUNT($B$3:B3)<=$D$3,INDEX(B:B,MATCH(0,B:B,0)-$D$3+ROW(A1)-1),"")
Hello Ford
Perfect Awesome thanks
thanks again
thilag
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks