Intersection of rows in excel through vba or direct kind help and duplicate permuted rows from csv

[vs140580]

I have a csv with n columns in it and it has say 500k rows. Now kind help with a way in excel for possible ways to pick n+1 rows such that intersection between any two rows is exactly one record in the entire row and all elements in n+1 rows together have each record in the row exactly only twice. Also problem to open such huge csv file. Can I remove duplicate rows of type if row has a b c d e respective 5 column and another b c a e d say a permuted of the first all fields strings how to identify delete such duplicate rows keepin only one.

 

[mikerickson]

I'm not sure what you mean by "intersection between two rows". Rows are parallel, they do not intersect.

 

[vs140580]

(0,1), (0,2), (0,3), (3,4)
(0,1), (1,3), (1,2), (2,4)
(0,2), (2,3), (1,2), (1,4)
(1,4), (2,4), (0,4),(0,3)

Each row contains each line of above and each column contains (0,1) next (0,2) etc so there are 4 columns and we have to choose 5 rows with five columns like this u can see the intersection there I feel

 

[mikerickson]

So, by intersection, you mean elements in common.

A row of cells containing a,b,c,d,e intersects with a row of cells b,x,a,y,z twice, on the elements a,b.

Is that your meaning?

And you want N+1 rows of N elements, such than there are N*(N+1) / 2 total elements, each duplicated twice.
Further more, the intersection of any two rows is at most 1 element.

Is that your requirement?

 

[vs140580]

In stead of at most one of any two rows is exactly one

 

[vs140580]

Thank you kind help

 

[vs140580]

Exactly 1

 

[vs140580]

If there are 5 lac rows and I have to split it into sheets two or more if possible how can do it with handling multiple sheets of data

 

[vs140580]

That is my requirement with exactly 1 in place of atmost 1