Data Analysis Question
 

I have a data set of numbers arranged in rows. They are 6 elements across.
Each data set is unique. There are many sets which are listed down the page.

I would like to see if there are common elements among the data sets. Ie 32
and 42 appear in 3 of the data sets, in row 1, 4 and 9. In Excel.


A B C D E F
1 32 42 45 29 12 99
2 20 347 54 3 68 56
3 18 13 412 23 348 90
4 131 8 32 464 25 6
5 15 20 24 55 3 99
6 3 73 84 5 542 189
7 35 36 45 56 57 45
8 54 85 75 34 65 69
9 13 25 94 2 4 12


Was this post helpful to you?

Data Analysis Question
 

I don't see a 32 in row 9

In any event, use Conditional formatting to highight the equal cells.

--
Regards,
Tom Ogilvy



"BRUZER" wrote in message
...
I have a data set of numbers arranged in rows. They are 6 elements across.
Each data set is unique. There are many sets which are listed down the
page.

I would like to see if there are common elements among the data sets. Ie
32
and 42 appear in 3 of the data sets, in row 1, 4 and 9. In Excel.


A B C D E F
1 32 42 45 29 12 99
2 20 347 54 3 68
56
3 18 13 412 23 348 90
4 131 8 32 464 25 6
5 15 20 24 55 3
99
6 3 73 84 5 542
189
7 35 36 45 56 57
45
8 54 85 75 34 65
69
9 13 25 94 2 4
12


Was this post helpful to you?