how to count matched pairs and triples and an additional question

[Edviper2710]

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 do 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 that 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.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.