In The attachment, i need to cut the highlighted rows and need it in column
EX:A1 and A7 as A1 and B1
A11 and A18 as A2 and B2
In The attachment, i need to cut the highlighted rows and need it in column
EX:A1 and A7 as A1 and B1
A11 and A18 as A2 and B2
No. Your explanation doies not make any sense (at least, not to me!!). More detail is needed. What do you expect to see? Where does it come from? Where do you expect to see it?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hello Glenn, You can see highlighted rows in the attached Excel. I need those highlighted rows in another sheet but in format which i asked
EX:
A1 and A7 as A1 and B1
A11 and A18 as A2 and B2
I have attached one excel sheet. We can see current output and expected output. I have manually edited to get the "expected output". I need some script to get the "Expected output"
To be clear. Your starting point is "Current Output". Yes or No??
Your desired solution is "Expected output. Yes or No?
What does sheet 3 have to do with it?
Yes..you are correct. Just leave sheet 3..nothing to do with the sheet3..
In A2, copied across and down:
=IFERROR(INDEX(Raw!B:B,AGGREGATE(15,6,ROW(Raw!$B$1:$B$400)/(Raw!$B$1:$B$400<>""),ROWS(A$2:A2))),"")
For Column "B" , =IFERROR(INDEX(Raw!C:C,AGGREGATE(15,6,ROW(Raw!$B$1:$B$400)/(Raw!$B$1:$B$400<>""),ROWS(B$2:B2))),"")
Column "C" , =IFERROR(INDEX(Raw!D:D,AGGREGATE(15,6,ROW(Raw!$B$1:$B$400)/(Raw!$B$1:$B$400<>""),ROWS(C$2:C2))),"")
Column "d" , =IFERROR(INDEX(Raw!E:E,AGGREGATE(15,6,ROW(Raw!$B$1:$B$400)/(Raw!$B$1:$B$400<>""),ROWS(D$2:D2))),"")
Column "e" =IFERROR(INDEX(Raw!F:F,AGGREGATE(15,6,ROW(Raw!$B$1:$B$400)/(Raw!$B$1:$B$400<>""),ROWS(E$2:E2))),"")
So like A2, we need to apply the same for all other columns right(B,C,D,E)
I do not understand you. On MY sheet, at Post 6, what was incorrect???
Everything is right. am just asking about remaining columns(B,C,D and E)
If you copy the formula cross and down, as I staed, the column letters will automatically increment to give you the correct result.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
please select "Thread Tools" from the menu link above and mark this thread as SOLVED
I couldn't find thread tools..Please guide me
It is just above your first post in this thread
Actually, I can mark it as solved, too. But it's probably better that you know how, as well as me.
Done, Thank you so much Glenn
Can you the explain the query which you write for this request?
=IFERROR(INDEX(Raw!B:B,AGGREGATE(15,6,ROW(Raw!$B$1:$B$400)/(Raw!$B$1:$B$400<>""),ROWS(A$2:A2))),"")
Red: For every row where this is true (ie non-blank)
Orange: return the row number
Green In order, smallest row number upwards (15) ignoring errors (6)
Cyan: (a counter) in order lowest row number, 2nd lowest, etc,
Blue: and return the corresponding value from column B
Black if the formula returns an error, return a blank instead.
You're welcome.
It'd be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks