excel to convert

Reply #4

timmsy — Tue, 30 Oct 2018 11:06:15 GMT

this excel vba code is all you need ,,,

Public Sub Highlight_Repetitions11()

REPEATS = Application.InputBox( How many numbers would you like to find Repetitions: , Type:=1)

Dim Rw1 As Range, Rw2 As Range

Dim check_array As Variant, match_array As Variant

Dim Wb As Workbook

For Each Wb In Application.Workbooks

If StrComp(Right(Wb.Name, 4), .CSV , vbTextCompare) = 0 Then

Wb.Close

End If

Next Wb

Range( AA2:AC20000 ).ClearContents

Reply #3

phileight — Tue, 30 Oct 2018 10:58:42 GMT

i do not use vtrac so my understanding may be wrong. what you are doing does not match what i understand.. provide your definition of vtrac and i will see if i can do anything with it.

Reply #2

Gwoof — Mon, 29 Oct 2018 17:46:47 GMT

I was looking at the individual digits.

Reply #1

phileight — Mon, 29 Oct 2018 17:05:34 GMT

What is your definition of Vtrac in this instance. With single digits I know what s vtrac is.

excel to convert

Gwoof — Mon, 29 Oct 2018 16:36:09 GMT

Does someone have an excel program which will show the 649 history and it's VTrac equivalent?

The next question is would it be useful information? Would it be easier to spot patterns or trends in each position?

eg.

Atlantic 649

history VTrac

10/27/2018 13,16,18,30,41,46 24,22,24,41,52,52

10/24/2018 01,10,11,31,33,41 12,21,22,42,44,52

10/20/2018 04,15,23,24,26,47 15,21,34,35,32,53

10/17/2018 15,21,27,31,32,45 21,32,33,42,43,51

10/13/2018 02,10,18,20,23,29 13,21,24,31,... [ More ]