View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Help Needed to Search and Find Specific Data

Hi Everyone,

I have a Worksheet with Combinations in the Format :-

01-02-03-04-05-06
01-02-03-04-05-07
01-02-03-04-05-08
etc

The Combinations are on a Worksheet Named "Combinations" and go from
A1:P65000 for example. Each Combination is in a SINGLE CELL.

What I would like to be able to do is to COUNT how many times the
following Combinations Appear in the Worksheet Named "Combinations" :-

01-02-03
03-05-08
01-02-03-04
03-04-05-08
01-02-03-04-05
04-05-06-07-08
01-02-03-04-05-06
etc

There could be as many as 30 or so to Check, Ranging from 3 Numbers up
to 6 Numbers.
The Combinations to Check will be in a Range on a Worksheet Named
"Results" in A1:A30 for example.
Is there a Formula I could use to achieve this or will it need to be
done using VB?.

Thanks very much in Advance.
Paul