How to return unique values from column, if source have duplicate values

[Manojlo]

Hello,
Can someone help me with formula.

I have first table with some values, in column B are unique values (example: cities), but in column C it is possible to have duplicate values.

In second table, I put LARGE formulas in column F to find me and put in descending order values from column C.

Now I need in column E formula to look for values in column F and match with values from column B (cities) but not to duplicate values (cities). Formula need to take account duplicate cities with same values and list them all

.

Thank you in advance

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G
1
2
3
4		Ward	No		Ward	No
5		Corbar	6		Limestone Peak	13
6		Limestone Peak	13		Greater Exmoor	13
7		Queensbury	2		Ullswater	13
8		Cote Heath	2		Tideswell	12
9		Barms	6		St James'	11
10		Temple	2		Manifold	10
11		Manifold	10		Bingley Rural	7
12		Tideswell	12		Corbar	6
13		Sutton	6		Barms	6
14		Greetland and Stainland	4		Sutton	6
15		St James'	11		Greetland and Stainland	4
16		Ryburn	2		Cleobury Mortimer	4
17		Bingley Rural	7		Queensbury	2
18		Illingworth and Mixenden	1		Cote Heath	2
19		Churnet	2		Temple	2
20		Greater Exmoor	13		Ryburn	2
21		Ullswater	13		Churnet	2
22		Cleobury Mortimer	4		Illingworth and Mixenden	1
23
Main

Cell Formulas
Range	Formula
E5:E22	E5	=INDEX($B$5:$B$22,AGGREGATE(15,6,(ROW($B$5:$B$22)-ROW($B$5)+1)/($C$5:$C$22=F5),COUNTIFS(F$5:F5,F5)))
F5:F22	F5	=LARGE($C$5:$C$22,ROWS(F$5:FF5))

 

[JoeMo]

If the result you want is as shown in cols E & F, why not copy the first table to E4 then sort on col F descending?

 

[Manojlo]

@Fluff Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.