I don't know if this is an Excel problem, or if it belongs somewhere else. If it shouldn't be here please excuse me and I'll drop it.
The table contains rows of five numbers. The aim is to select as many rows as possible without duplicating any of the numbers. The full table is larger than this one, but I hope there's enough data to illustrate the question.
4,5,206,219,273
7,13,52,267,271
8,24,96,117,193
9,16,29,51,282
10,16,48,114,230
11,22,117,275,282
11,68,88,95,214
12,26,113,175,220
12,36,113,127,216
13,18,124,263,264
13,21,124,204,268
13,35,102,142,219
17,39,76,181,201
17,43,52,158,251
18,19,60,68,198
19,30,104,155,164
19,31,104,155,164
19,33,128,248,252
19,57,73,249,282
20,44,101,211,252
20,49,126,146,252
20,52,80,209,273
21,45,81,166,220
21,61,82,200,247
22,34,72,124,244
The table contains rows of five numbers. The aim is to select as many rows as possible without duplicating any of the numbers. The full table is larger than this one, but I hope there's enough data to illustrate the question.
4,5,206,219,273
7,13,52,267,271
8,24,96,117,193
9,16,29,51,282
10,16,48,114,230
11,22,117,275,282
11,68,88,95,214
12,26,113,175,220
12,36,113,127,216
13,18,124,263,264
13,21,124,204,268
13,35,102,142,219
17,39,76,181,201
17,43,52,158,251
18,19,60,68,198
19,30,104,155,164
19,31,104,155,164
19,33,128,248,252
19,57,73,249,282
20,44,101,211,252
20,49,126,146,252
20,52,80,209,273
21,45,81,166,220
21,61,82,200,247
22,34,72,124,244