MyHeadAches
New Member
- Joined
- Apr 28, 2013
- Messages
- 4
Hello all,
I am having some difficulty in trying to get my head around a problem I am having in analyzing data in Excel and was hoping one of you wizards may be able to help me.
I have approximately 2000 rows of numerical data in 7 columns. I need to find the most frequent three numbers that occur on a row in any of the 7 columns.
Below is an example of what I mean:
3, 43 and 44 appear together in two rows but not in any particular order, and;
2, 17 and 39 appear three times together in a row but again not in any particular order.
The numbers do not need to be in any order or pattern just on the same row as each other.
<tbody>
</tbody>
I think a macro might be able to obtain the results I need but it is well beyond my understanding - Does it sound like something that could be done? I'd very much appreciate some assistance if it's possible.
Thanks in advance,
MyHeadAches!
I am having some difficulty in trying to get my head around a problem I am having in analyzing data in Excel and was hoping one of you wizards may be able to help me.
I have approximately 2000 rows of numerical data in 7 columns. I need to find the most frequent three numbers that occur on a row in any of the 7 columns.
Below is an example of what I mean:
3, 43 and 44 appear together in two rows but not in any particular order, and;
2, 17 and 39 appear three times together in a row but again not in any particular order.
The numbers do not need to be in any order or pattern just on the same row as each other.
<tbody> </tbody> |
<tbody>
</tbody>
I think a macro might be able to obtain the results I need but it is well beyond my understanding - Does it sound like something that could be done? I'd very much appreciate some assistance if it's possible.
Thanks in advance,
MyHeadAches!