Hi
I'm kindly asking for excel formula which can combine two different list of boys and girls into one list as shown on the desired outcome.
Thank you.
Hi
I'm kindly asking for excel formula which can combine two different list of boys and girls into one list as shown on the desired outcome.
Thank you.
Format both lists (Boys and Girls) as Tables, then you can use Power Query to easily combine:
Close and Load To a table, to get the combined output.Please Login or Register to view this content.
See attachment for example.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Formula (there's probably a better way though)...
I6
=IF(J6="","",INDEX($A:$G,SUM(INDEX((TRIM($B$6:$F$100)=$J6)*ROW($B$6:$F$100),)),SUM(INDEX((TRIM($B$6:$F$100)=$J6)*COLUMN($B$6:$F$100),))-1))
J6
=SORT(FILTERXML("<A><B>"&TEXTJOIN("</B><B>",,B6:B100,F6:F100)&"</B></A>","//B"))
K6
=IF(J6="","",INDEX($A:$G,SUM(INDEX((TRIM($B$6:$F$100)=$J6)*ROW($B$6:$F$100),)),SUM(INDEX((TRIM($B$6:$F$100)=$J6)*COLUMN($B$6:$F$100),))+1))
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
Hi Olly and Glenn
Thank you for the formulas. There are working well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks