Ordering the impossible!

[EWSDustin]

Hi!

Sorry, I can't make work the mini sheet, what would make it easier to show.
What I am looking for I'm not even sure if its possible.

In an Excel I have (Sheet A), with a (very long) list with a number of items. The list may contain repeated articles.

Then I have a second list (Sheet B), which contains the same articles, but here they are never repeated.

I have managed with conditional formatting and a small formula, to mark with a color one article of each from Sheet A, this way using the filter function, I can ask it to show only the blue articles, and paste next to it the articles from Sheet B, which is the final goal. I will put several photos of example in case it can be seen this way clearer.

What I need is that the articles from Sheet B are aligned with one of their identical articles of sheet B.
It's not necessary to have colors, table format, etc.

Is there any way, with or without macros, to align the items?
Thx in advance!

Sheet A	Sheet A	Sheet A	Sheet A		Sheet B	Sheet B	Sheet B
Supplier	Container	Product	Article​
LIDL ASIA (FOB)​	FSCU8234787​	UHRENKASTEN 2FACH SORT.​	359547		359547	6	6
LIDL ASIA (FOB)​	HLBU1682450​	UHRENKASTEN 2FACH SORT.​	359547		359556	5	5
LIDL ASIA (FOB)​	HLBU2866196​	UHRENKASTEN 2FACH SORT.​	359547		359560	2	2
LIDL ASIA (FOB)​	TLLU5394140​	UHRENKASTEN 2FACH SORT.​	359547		359631	2	2
LIDL ASIA (FOB)​	UACU5339988​	UHRENKASTEN 2FACH SORT.​	359547		359657	1	1
LIDL ASIA (FOB)​	UACU8546510​	UHRENKASTEN 2FACH SORT.​	359547
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	CAAU5939644​	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.​	359556
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	MIEU2003018​	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.​	359556
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	MSKU5014698​	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.​	359556
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	MSKU9102755​	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.​	359556
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	TRHU5664613​	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.​	359556
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	CCLU6914704​	HOLZ KÜCHE FSC​	359560
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	CSNU6618676​	HOLZ KÜCHE FSC​	359560
TARGA (DDP)​	TGBU6843965​	MILCHAUFSCHäUMER SMA 500 E1​	359631
TARGA (DDP)​	TLLU6844197​	MILCHAUFSCHäUMER SMA 500 E1​	359631
DELTA-SPORT HANDELSKONTOR GMBH (DDP)​	MSKU8255750​	HOLZ SCHAUKELTIER ESEL FSC​	359657

 

[Toadstool]

Hi EWSDustin,

I'm not sure if I've correctly interpreted your requirement so how close is this?

EWSDustin.xlsx
	A	B	C
1
2
3	Article Nr.	Ctr	Amount of Measurements
4	359547	6	6
5	359556	5	5
6	359560	2	2
7	359631	2	2
8	359657	1	1
9
Sheet B

EWSDustin.xlsx
	A	B	C	D	E	F	G
1
2
3	Supplier	Container	Product	Article	Column1	Column2	Column3
4	LIDL ASIA (FOB)	FSCU8234787	UHRENKASTEN 2FACH SORT.	359547
5	LIDL ASIA (FOB)	HLBU1682450	UHRENKASTEN 2FACH SORT.	359547
6	LIDL ASIA (FOB)	HLBU2866196	UHRENKASTEN 2FACH SORT.	359547
7	LIDL ASIA (FOB)	TLLU5394140	UHRENKASTEN 2FACH SORT.	359547
8	LIDL ASIA (FOB)	UACU5339988	UHRENKASTEN 2FACH SORT.	359547
9	LIDL ASIA (FOB)	UACU8546510	UHRENKASTEN 2FACH SORT.	359547	359547	6	6
10	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	CAAU5939644	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
11	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MIEU2003018	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
12	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MSKU5014698	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
13	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MSKU9102755	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
14	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	TRHU5664613	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556	359556	5	5
15	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	CCLU6914704	HOLZ KÜCHE FSC	359560
16	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	CSNU6618676	HOLZ KÜCHE FSC	359560	359560	2	2
17	TARGA (DDP)	TGBU6843965	MILCHAUFSCHäUMER SMA 500 E1	359631
18	TARGA (DDP)	TLLU6844197	MILCHAUFSCHäUMER SMA 500 E1	359631	359631	2	2
19	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MSKU8255750	HOLZ SCHAUKELTIER ESEL FSC	359657	359657	1	1
Sheet A

Cell Formulas
Range	Formula
E4:E19	E4	=IF(COUNTIF($D$4:$D4,[@Article])=COUNTIF([Article],[@Article]),INDEX('Sheet B'!$A$4:$A$10000,MATCH([@Article],'Sheet B'!$A$4:$A$10000,0)),"")
F4:G19	F4	=IF([@Column1]<>"",INDEX('Sheet B'!B$4:B$10000,MATCH([@Article],'Sheet B'!$A$4:$A$10000,0)),"")

 

[EWSDustin]

Hi EWSDustin,

I'm not sure if I've correctly interpreted your requirement so how close is this?

EWSDustin.xlsx
	A	B	C
1
2
3	Article Nr.	Ctr	Amount of Measurements
4	359547	6	6
5	359556	5	5
6	359560	2	2
7	359631	2	2
8	359657	1	1
9
Sheet B

EWSDustin.xlsx
	A	B	C	D	E	F	G
1
2
3	Supplier	Container	Product	Article	Column1	Column2	Column3
4	LIDL ASIA (FOB)	FSCU8234787	UHRENKASTEN 2FACH SORT.	359547
5	LIDL ASIA (FOB)	HLBU1682450	UHRENKASTEN 2FACH SORT.	359547
6	LIDL ASIA (FOB)	HLBU2866196	UHRENKASTEN 2FACH SORT.	359547
7	LIDL ASIA (FOB)	TLLU5394140	UHRENKASTEN 2FACH SORT.	359547
8	LIDL ASIA (FOB)	UACU5339988	UHRENKASTEN 2FACH SORT.	359547
9	LIDL ASIA (FOB)	UACU8546510	UHRENKASTEN 2FACH SORT.	359547	359547	6	6
10	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	CAAU5939644	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
11	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MIEU2003018	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
12	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MSKU5014698	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
13	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MSKU9102755	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556
14	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	TRHU5664613	HOLZ SCHMINKTISCH, EINKAUFSWAGEN, WERKBANK FSC 3FACH SORT.	359556	359556	5	5
15	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	CCLU6914704	HOLZ KÜCHE FSC	359560
16	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	CSNU6618676	HOLZ KÜCHE FSC	359560	359560	2	2
17	TARGA (DDP)	TGBU6843965	MILCHAUFSCHäUMER SMA 500 E1	359631
18	TARGA (DDP)	TLLU6844197	MILCHAUFSCHäUMER SMA 500 E1	359631	359631	2	2
19	DELTA-SPORT HANDELSKONTOR GMBH (DDP)	MSKU8255750	HOLZ SCHAUKELTIER ESEL FSC	359657	359657	1	1
Sheet A

Cell Formulas
Range	Formula
E4:E19	E4	=IF(COUNTIF($D$4:$D4,[@Article])=COUNTIF([Article],[@Article]),INDEX('Sheet B'!$A$4:$A$10000,MATCH([@Article],'Sheet B'!$A$4:$A$10000,0)),"")
F4:G19	F4	=IF([@Column1]<>"",INDEX('Sheet B'!B$4:B$10000,MATCH([@Article],'Sheet B'!$A$4:$A$10000,0)),"")

It works!
Whenever I am given a formula, instead of copying and pasting it and moving on, I try to recreate it step by step and understand what each parentisis refers to, so I can understand it. What I still find very difficult is to know which functions to use without having an example in front of me, like in a puzzle, I can only understand it if I have the final example in front of me, without it, I wouldn't know which pieces should fit together.
Thank you very much for your help,

 

[Toadstool]

It works!
Whenever I am given a formula, instead of copying and pasting it and moving on, I try to recreate it step by step and understand what each parentisis refers to, so I can understand it. What I still find very difficult is to know which functions to use without having an example in front of me, like in a puzzle, I can only understand it if I have the final example in front of me, without it, I wouldn't know which pieces should fit together.
Thank you very much for your help,

You're welcome.

Don't worry as you're not alone. Many of the solutions on the forum are responded to with "Of course!" (and I've made such exclamations) as the questioner remembers the function or demonstrated technique.