The source area is in column A and column B
Form a horizontal de-duplication and arrange the amount from large to large
Any help would be appreciated!
The source area is in column A and column B
Form a horizontal de-duplication and arrange the amount from large to large
Any help would be appreciated!
Last edited by metrostar; 08-28-2022 at 08:35 PM.
In E2:
=UNIQUE(A2:A12)
In F2 copied down:
=TRANSPOSE(SORT(UNIQUE(FILTER(B2:B12,A2:A12=E2)),,-1))
Last edited by AliGW; 08-28-2022 at 06:29 AM. Reason: Added example workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks AliGW you're awesome Can this be done with the LET function?
What do you mean? What is wrong with the formulae I gave you?
Try
First clear the E1:J6 area, then Cell E1 place this formula
Formula:Please Login or Register to view this content.
Nice one!
If you don't want the header row, try this:
=DROP(REDUCE(IF(C1:D1=0,""),UNIQUE(A2:A12),LAMBDA(x,y,IFERROR(VSTACK(x,HSTACK(y,TRANSPOSE(SORT(UNIQUE(FILTER(B2:B12,A2:A12=y)),,-1)))),""))),1)
No title
Cell E2 formula
Formula:Please Login or Register to view this content.
The formula both provided is amazing. The problem is solved
@metrostar You're Welcome. Glad to help . Thank You for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks