extract raws/values without duplication

[dofrancis]

Dear colleagues;


Could you help me to have a formula who can help me to extract values without duplication.

 

[hagia_sofia]

Hello, in 365 just:

UNIQUE(A2:D10)

 

[Peter_SSs]

You could even include the heading row to get those by the formula as well.

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

24 10 28.xlsm
	A	B	C	D	E	F	G	H	I	J
1	REGION	DISTRICT	Target	Reach
2	Region 1	District 1	900	810
3	Region 1	District 1	900	810			REGION	DISTRICT	Target	Reach
4	Region 2	District 2	450	382			Region 1	District 1	900	810
5	Region 2	District 2	450	382			Region 2	District 2	450	382
6	Region 2	District 2	450	382			Region 3	District 3	860	856
7	Region 2	District 2	450	382
8	Region 3	District 3	860	856
9	Region 3	District 3	860	856
10	Region 3	District 3	860	856
Sheet8

Cell Formulas
Range	Formula
G3:J6	G3	=UNIQUE(A1:D10)
Dynamic array formulas.