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.
@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
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)))))
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.
I need B10 to 21 ... see the sequence.... Same sequences i need.
is it ok if I Create a Helper Column for you
Without Helper Column
B10Try this and copy towards downPlease Login or Register to view this content.
with Helper Column
E2Copy towards downPlease Login or Register to view this content.
B10Try this and copy towards downPlease Login or Register to view this content.
Yes it is ok with me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks