Hi Masters,
I have two data base and a unique list from both of data set. I need to plot both data into one column according unique list sequence.
Please check the attached file as suggest me what to do??
Sincerely Your's.
Ankur Shukla
Hi Masters,
I have two data base and a unique list from both of data set. I need to plot both data into one column according unique list sequence.
Please check the attached file as suggest me what to do??
Sincerely Your's.
Ankur Shukla
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)
Will the unique list sequence always be alphanumeric and from A-Z, or is the idea that it will change? If the latter, then you will realise that we need more representative data.
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.
I actually came with below formula which actually work but it is too hard coding to type regular.
=IFERROR(IFERROR(IFERROR(INDEX($A$2:$A$13,AGGREGATE(15,6,ROW($A$1:$A$12)/($A$2:$A$13=$D$2),ROWS($A$1:A1))),INDEX($A$2:$A$13,AGGREGATE(15,6,ROW($A$1:$A$12)/($A$2:$A$13=$D$3),ROWS($A$1:A1)-SUMPRODUCT(--($A$2:$A$13=$D$2))))),INDEX($A$2:$A$13,AGGREGATE(15,6,ROW($A$1:$A$12)/($A$2:$A$13=$D$4),ROWS($A$1:A1)-SUMPRODUCT(--($A$2:$A$13=$D$2))-SUMPRODUCT(--($A$2:$A$13=$D$3))))),INDEX($A$2:$A$13,AGGREGATE(15,6,ROW($A$1:$A$12)/($A$2:$A$13=$D$5),ROWS($A$1:A1)-SUMPRODUCT(--($A$2:$A$13=$D$2))-SUMPRODUCT(--($A$2:$A$13=$D$3))-SUMPRODUCT(--($A$2:$A$13=$D$5)))))
@AligW Unique List always retrieve from Data1 and Data2 sequences is most important. Sequence of unique list prepared by another person and I have to do according him
It can be random....
Boom anyone can help me.
you are looking for
unique list or
Required as below or both
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Yes it is ok with me
I need B10 to 21 ... see the sequence.... Same sequences i need.
Without Helper Column
B10Try this and copy towards down=IF(ROWS(B$10:B10)>SUMPRODUCT(COUNTIFS($A$2:$B$7,$D$2:$D$5)),"",LOOKUP(ROWS(B$10:B10),MMULT((ROW(INDIRECT("A1"):INDEX(INDIRECT("A:A"),ROWS($D$2:$D$5)))>=COLUMN(INDIRECT("A1"):INDEX(INDIRECT("1:1"),ROWS($D$2:$D$5))))+0,COUNTIFS($A$2:$B$7,$D$2:$D$5))-COUNTIFS($A$2:$B$7,$D$2:$D$5)+1,D$2:D$5))
with Helper Column
E2Copy towards down=IF(ROWS(E$2:E2)=1,1,SUM(E1,COUNTIF($A$2:$B$7,D1)))
B10Try this and copy towards down=IF(ROWS(B$10:B10)>SUMPRODUCT(COUNTIFS($A$2:$B$7,$D$2:$D$5)),"",INDEX(D$2:D$5,MATCH(ROWS(B$10:B10),$E$2:$E$5)))
is it ok if I Create a Helper Column for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks