Hello Friends
Please find the attached file (Skip the date which has blank value 310316.xlsx).
I need to skip the date has blank value and remaining need to be plotted.
Hello Friends
Please find the attached file (Skip the date which has blank value 310316.xlsx).
I need to skip the date has blank value and remaining need to be plotted.
Sekar
Try
D2=IFERROR(INDEX($A$2:$A$32,SMALL(IF($B$2:$B$32<>"",ROW($B$2:$B$32)-ROW($B$2)+1),ROWS($A$1:A1))),"") with CRTL+SHIFT+ENTER and drag down.
or
D2=IFERROR(INDEX($A$2:$A$32,AGGREGATE(15,6,ROW($A$2:$A$32)-ROW($A$2)+1/($B$2:$B$32<>""),ROWS($A$1:A1))),"") and drag down.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
This ARRAY formula will produce the table in yellow...
=IFERROR(INDEX(A:A,SMALL(IF($B$2:$B$32<>"",ROW($A$2:$A$32)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
then 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
Thanks to Anlur and Thanks to Ford
Your formulas working fine.
thanks again
Happy to help and thank for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks