Data Analysis Question

B

BRUZER

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?
 
T

Tom Ogilvy

I don't see a 32 in row 9

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Match Formula? 7
How to group a table using VBA? 3
For Loop 9
Record Click on Error Indicator 2
Outlook 2010 can't find .pst file 1
Gears 14
Removing Sequential Numbers 5
Sumproduct Problem 4

Top