$$Excel-Macros$$ Re: Parse through a data range

2009-07-06 Thread Levi Small
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

$$Excel-Macros$$ Re: Parse through a data range

2009-07-06 Thread Levi
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

$$Excel-Macros$$ Re: Parse through a data range

2009-06-30 Thread Levi Small
Sorry I was not sure I could attach to the post. I have a ttached a workbook that I would like to figureout how to parse through. On Thu, Jun 25, 2009 at 5:27 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Levi, We need to know how this data range looks. Any chance of attaching a

$$Excel-Macros$$ Re: Parse through a data range

2009-06-25 Thread Dave Bonallack
Hi Levi, We need to know how this data range looks. Any chance of attaching a sample workbook? Regards - Dave. Date: Wed, 24 Jun 2009 07:12:03 -0700 Subject: $$Excel-Macros$$ Parse through a data range From: rlsmalls...@gmail.com To: excel-macros@googlegroups.com I am wanting to parse

$$Excel-Macros$$ Re: Parse through a data range

2009-06-24 Thread Nishant Jain
Any examples? On Jun 24, 7:12 pm, Levi rlsmalls...@gmail.com wrote: I am wanting to parse through a data range one row at a time.  Looking for pairs of numbers.  Then display the results of the most common pairs in a cell on the Excel spreadsheet.  Can anyone help with a task like this?