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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Counting matched pairs and triples + additional question
0
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?
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: 197) 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: 4889) Jul 8, '19 at 10:27 pm