Sir,
I have been facing this peculiar problem to transpose the data in excel. I have used INDEX, MATCH and even V LOOKUP, but couldn't find a feasible solution.
Please assist.
I have attached the requisite file.
Sir,
I have been facing this peculiar problem to transpose the data in excel. I have used INDEX, MATCH and even V LOOKUP, but couldn't find a feasible solution.
Please assist.
I have attached the requisite file.
Last edited by avinash21; 11-27-2019 at 03:55 AM.
In C8, a helper, copied down:
=IF(B8="",I7,B8)
In K5, copied to L5 & down:
IFERROR(INDEX(B$8:B$30,MATCH(0,INDEX(COUNTIF(K$3:$K4,B$8:B$30&""),),0)),"")
In m5, with similar formulae in P &S
=IFERROR(INDEX($F$8:$F$30,MATCH(1,INDEX(($I$8:$I$30=$K5)*($E$8:$E$30=100*M$3),0),0)),"")
The formulae in the amount cells need an error statement:
=IFERROR($M5*($M$3/2),"")
Only done for column N.
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Brother Glenn Kennedy ,
I have copied the formula from K5 to L5. but, it shows in-correct result when L4 & L5 as same values after this, the results in C & L column do not match.
Kindly assist.
I should have said dragged, not copied. Beyond that, i can not diagnose the problem if I can not see what you have done.
Do you accept that it was working the the sheet that I posted?
It's okay brother. I have applied the formula only to numerical & Excel has done a great job here (and not to names). I'm very thankful to you for getting the work done.
Consider this thread as solved.
Thank you once again!
-With Love from India.
Last edited by avinash21; 11-27-2019 at 05:44 AM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks