| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find the most common pair and triplet numbers?
Hi
I have been looking into this for few weeks now but I can't find a solution ... I have 200 rows of data composed of numbers from 1 to 10 on column A to F. I need to find out the most pair / triplet for the all table. Perhaps the following example will explain better 1_2_3_4_5_6 1_2_5_6_7_9 2_3_5_6_7_8 3_4_6_7_8_9 1_3_5_6_7_8 Most common pair = 6_7 Most common triplet = 5_6_7 Hope this is clear ... thank you in advance A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find the most common numbers? | New Users to Excel | |||
| From 2 rows or column how to find common numbers | Excel Discussion (Misc queries) | |||
| count and return pair numbers | Excel Worksheet Functions | |||
| Need code to pair off numbers | Excel Programming | |||
| in excel, how do I find which value doesn't have a pair? | Excel Discussion (Misc queries) | |||
Threaded Mode
