compile two columns according sequence of unique list

[shukla.ankur281190]

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

[AliGW]

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.

[shukla.ankur281190]

@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

[AliGW]

@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

So, what are you saying in answer to my question? Will the order always be A-Z, or could it be random?

[shukla.ankur281190]

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)))))

[shukla.ankur281190]

It can be random....

[shukla.ankur281190]

Boom anyone can help me.

[samba_ravi]

you are looking for
unique list or
Required as below or both

[shukla.ankur281190]

I need B10 to 21 ... see the sequence.... Same sequences i need.

[samba_ravi]

is it ok if I Create a Helper Column for you

[samba_ravi]

Without Helper Column
B10

Please Login or Register  to view this content.

Try this and copy towards down
with Helper Column
E2

Please Login or Register  to view this content.

Copy towards down
B10

Please Login or Register  to view this content.

Try this and copy towards down

[shukla.ankur281190]

Yes it is ok with me