Return each value in column B, for ID in column A

[surkdidat]

I require a formula that looks at the code in column A, and then returns the next value that is not already in the list. The values may or may not be unique.


Raw Data

	Column A	Column B
Row 1	ID	Code
Row 2	2101773	aaaaa
Row 3	2169394	sdjkih
Row 4	2158156	dsadd
Row 5	2101773	nuihiu
Row 6	2101773	fsdfsf
Row 7	2101773	aaaaa

Required output

	Column A	Column B
	ID	Code
Row 1	2101773	aaaaa
Row 2	2101773	nuihiu
Row 3	2101773	fsdfsf
Row 4	2101773	aaaaa

 

[alansidman]

If I understand, then you can just filter the values in column A and sort Ascending.

 

[surkdidat]

The data needs to be transferred into another sheet where the user inputs the code, and is a couple of hundred thousand lines

 

[alansidman]

After filtering, copy and paste. You are piecemealing us here. Specifics really expedite a workable answer.

 

[surkdidat]

After filtering, copy and paste. You are piecemealing us here. Specifics really expedite a workable answer.

Hi there, thank you for your answer, the issue is I would need to repeat this for nearly 1000 people, but if there is not a better way I will need to see what other solutions I can come up with!

 

[alansidman]

I would urge then to use Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"ID"}, {{"Count", each _, type table [ID=number, Code=text]}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"Code"}, {"Code"})
in
    #"Expanded Count"

When you close and load, you can select the destination.

Book9
	A	B	C	D	E
1	ID	Code		ID	Code
2	2101773	aaaaa		2101773	aaaaa
3	2169394	sdjkih		2101773	nuihiu
4	2158156	dsadd		2101773	fsdfsf
5	2101773	nuihiu		2101773	aaaaa
6	2101773	fsdfsf		2169394	sdjkih
7	2101773	aaaaa		2158156	dsadd
Sheet1

 

[SunnyAlv]

to be transferred into another sheet where the user inputs the code,

where is it, is it still in one workbook or in another workbook? maybe I can help

and do you have to filter it ID by ID and copy it somewhere else or something like that?