Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Database Analysis Question | Excel Worksheet Functions | |||
Database Analysis Question | Excel Discussion (Misc queries) | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |