Counting matched pairs and triples + additional question

0

I have a spreadsheet with 115 lines of 10 units of data on each line. 5 different numbers and 5 different letters on each line. I m trying to find out how I write a macro to show me the matched pairs and matched triples on this spreadsheet. My other question is how do I count all the numbers of the spreadsheet and I can delete all the lines that dont have a choosen number. I would like to learn how to count sequences, so I ve to count all the numbers of the spreadsheet and delete all the lines that does not have that number, so I can count it again. My excel isnt counting letters, so I have to find out how to program the excel to count both letters and numbers together. If you can help, please let me know how I do it. I really wanna make this statistical report.

Answer
Discuss

Discussion

Hi Ed 
Could you clarify what you mean by a matched pair and a matched triple.
is it that the same number/letter appears more than once on the same line?
Or is it that the exact same number letter sequence appears on more than one line for a matched pair and more than 2 lines for a matched triple. What do you do if there are 4 matches.
does 123aab match 321b in any way   
If you could provide a sample highlighting what is a match would be helpfull 
Also what you have tried so far.
Also how do you want the results displayed - another sheet? Msgbox? user form? email?
k1w1sm (rep: 82) Jul 8, '19 at 10:23 pm
no way to start answering any of your questions without a sample workbook to demonstrate on. Best method, create one sheet which has the data and another on which to show the desired result. That would automatically limit your questions to one at a time which fits the format of this forum. If it better suits your progress, you can ask several questions using the same setup at the same time but not within the same thread.
Variatus (rep: 2813) Jul 8, '19 at 10:27 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login