Formula to get unique values based on 3 columns?

[Fractalis]

Hi all, I have the input table from A1:G28. My goal is get to get the unique rows based on 3 columns (A, C and G). The output would be like
the table in M1:O14.

I was able to get this table manually joining the 3 columns I need, then Data/Remove duplicates for values in column I. I got unique values
in K2:K14. Finally I splitted column I to get table in M1:O14.

How can this be done in a single Excel Formula? Thanks.

file.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	H1	H2	H3	H4	H5	H6	H7		Joined		Unique Joined		H1	H3	H7
2	2	XYUO	HY	R	726	P	Z		2-HY-Z		2-HY-Z		2	HY	Z
3	2	XYUO	HY	R	281	P	Z		2-HY-Z		2-HY-R		2	HY	R
4	2	XYUO	HY	R	136	P	Z		2-HY-Z		2-HY-M		2	HY	M
5	2	XYUO	HY	R	814	P	R		2-HY-R		3-HY-B		3	HY	B
6	2	XYUO	HY	R	295	P	M		2-HY-M		3-BM-B		3	BM	B
7	3	PRO5U	HY	R	547	P	B		3-HY-B		3-HY-H		3	HY	H
8	3	PRO5U	HY	R	981	P	B		3-HY-B		2-HY-H		2	HY	H
9	3	PRO5U	HY	R	274	P	B		3-HY-B		2-BM-W		2	BM	W
10	3	PRO5U	BM	R	164	P	B		3-BM-B		2-BM-C		2	BM	C
11	3	PRO5U	BM	R	130	P	B		3-BM-B		3-BM-G		3	BM	G
12	3	PRO5U	BM	R	317	P	B		3-BM-B		3-BM-Z		3	BM	Z
13	3	PRO5U	BM	R	702	P	B		3-BM-B		3-HY-Z		3	HY	Z
14	3	PRO5U	HY	R	485	P	B		3-HY-B		3-BM-P		3	BM	P
15	3	PRO5U	HY	R	780	P	B		3-HY-B
16	3	TTRW	HY	R	628	P	H		3-HY-H
17	2	TTRW	HY	R	693	P	H		2-HY-H
18	2	TTRW	HY	R	980	P	H		2-HY-H
19	2	TTRW	HY	R	498	P	H		2-HY-H
20	2	TTRW	BM	R	870	P	W		2-BM-W
21	2	TTRW	BM	R	846	P	C		2-BM-C
22	2	TTRW	BM	R	720	P	C		2-BM-C
23	3	TTRW	BM	R	989	P	G		3-BM-G
24	3	TTRW	BM	R	353	P	Z		3-BM-Z
25	3	TTRW	HY	R	703	P	Z		3-HY-Z
26	3	TTRW	BM	R	605	P	Z		3-BM-Z
27	3	TTRW	BM	R	496	P	P		3-BM-P
28	3	TTRW	BM	R	914	P	Z		3-BM-Z
Sheet1

Cell Formulas
Range	Formula
M2:O14	M2	=TEXTSPLIT(K2,"-")
I2:I28	I2	=A2&"-"&C2&"-"&G2
Dynamic array formulas.

 

[hagia_sofia]

Put this into M2:

=UNIQUE(CHOOSECOLS(A2:G28,1,3,7))

 

[Cubist]

If you prefer to be more explicit with the column references you can use HSTACK. This makes the columns dynamic (robust if you insert or remove columns).

=UNIQUE(HSTACK(A2:A28,C2:C28,G2:G28))

 

[Fractalis]

Put this into M2:

=UNIQUE(CHOOSECOLS(A2:G28,1,3,7))

If you prefer to be more explicit with the column references you can use HSTACK. This makes the columns dynamic (robust if you insert or remove columns).

=UNIQUE(HSTACK(A2:A28,C2:C28,G2:G28))

Thanks so much both for your solutions. Easier than I thought.