...

Remove duplicate rows

 

The Excel table below has 7 columns of numbers. Some rows are completely same.

A

B

C

D

E

F

G

1

1

2

3

4

5

6

7

2

7

6

5

4

3

2

1

3

1

2

3

4

5

6

7

4

1

2

3

4

5

6

7

5

1

1

1

1

1

1

1

6

1

1

1

1

1

1

1

7

7

7

7

7

7

7

7

We want to remove duplicate rows.

I

J

K

L

M

N

O

1

7

6

5

4

3

2

1

2

7

7

7

7

7

7

7

Enter the following formula in SPL XLL:

=spl("=?.group(~).select(~.len()==1).conj()",A1:G7)

Picture1png

group()function groups rows. select() function gets groups meeting the specified condition. conj() function concatenates the selected groups.

Source:https://www.reddit.com/r/excel/comments/1cemf95/comment/l30zoco/


 
 •  69 View  •