I m still not clear, can you explain 1st line of Input and how you derived
result.
On Thu, Jun 12, 2014 at 1:34 AM, Will Sob wrote:
> Hi Joshi,
>
> this is my data
> 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28
> 29 48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19
Hi Joshi,
this is my data
7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 29
48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19 3 5 8 10 16 17 46 16 17
22 38 44 49 14 1 7 9 27 30 48 28 9 25 34 37 44 45 6 17 22 23 33 36 42 12
16 18 29 34 35 39 40 13 20 31 34 36 44 11
hi
can you illustrate an example.. we can help you on that..
Cheers!!
On Wed, Jun 11, 2014 at 2:17 AM, Will Sob wrote:
> thanks it did work but it did not build the triplets i specify
>
> it just calculated it to 18424
>
>
> On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote:
>
>> Here you
thanks it did work but it did not build the triplets i specify
it just calculated it to 18424
On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote:
> Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long
>
> when vale of m drops belwo 1 you will get error 9
>
> change lines to..
>
> Dim tb
Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long
when vale of m drops belwo 1 you will get error 9
change lines to..
Dim tbl(0 To ntbl, 1 To 2) As Long
can comment whether this will work without your sample data.
Cheers!!
On Tue, Jun 10, 2014 at 10:41 AM, Vaibhav Joshi wrote:
> He
Dear Expert,
Please look at this code what is wrong with it I'm not an expert in VBA but
would need some of your knowledge in this matter
I want to put together a formula that takes say a 6/49 lotto and point out
say I want to find the most occurring triples, it finds them and show how
many times
Hi
change line to
LastRow = Workbooks("Quantum
R-Creator.xlsm").Worksheets("Dump").Range("E1048576").End(xlUp).Row
+ 1
If you include workbook name then you need to also add file extension too.
Cheers!!
On Mon, Jun 9, 2014 at 11:07 PM, Secret Shot wrote:
> Dear Expert,
>
> I am working on a