Jayell, This is good stuff, thanks. Although the spreadsheet shows a count I was actually looking to find which pair of numbers show the most often in a particular row or column. In the spreadsheet it shows if the number repeats in a column and if so how many times this is just for that particular number and not a set of numbers. The idea is to capture the combonation that shows the most. For example, if 1 and 2 show up once in a row and then 10 and 7 show up 3 times in the same row I would want the macro to report that 7 and 10 showed up the most number of times together as a pair. I would not care about 1 and 2 until they showed the most number of times. Again than you for the spreadsheet this helps.
Levi On Jul 3, 8:15 pm, "john lyons" <john.lyo...@three.com.au> wrote: > Levi, > > The attached file has a few formulas that may be of some use > to you. > > If this does'nt help you to get there, maybe someone can > help with some > alternatives or some VBA macros. > > Regards, > Jayell > > Parse_01.xls > 34KViewDownload --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
