View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] alessio971@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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