excel again :)

[Still]

I found this; I will try to modify it in order to cut first 3 numbers and 11,12,13º...21,22,23º and so on.

Code Select Expand

Sub Delete_Alternate_Rows_Excel()
    Dim SourceRange As Range

    Set SourceRange = Application.Selection
    Set SourceRange = Application.InputBox("Range:", "Select the range", SourceRange.Address, Type:=8)

    If SourceRange.Rows.Count >= 3 Then
        Dim FirstCell As Range
        Dim RowIndex As Integer

        Application.ScreenUpdating = False

        For RowIndex = SourceRange.Rows.Count To 1 Step -2
            Set FirstCell = SourceRange.Cells(RowIndex, 1)
            FirstCell.EntireRow.Delete
        Next

        Application.ScreenUpdating = True

    End If
End Sub

Notice the code is stepping downward from the highest numbered rows to the lowest. 

In your example, it looked like you were deleting the lower rows first, which could adversely affect the rest of the deletions. 

Otherwise, yah, that code can be modified to do exactly what you want. 

[Herby]

Still is right:
the code has to be reversed

Code Select Expand

Sub deleteMultipleRows()

    Worksheets("Delete row").Rows("31:33").Delete
    Worksheets("Delete row").Rows("21:23").Delete
    Worksheets("Delete row").Rows("11:13").Delete
    Worksheets("Delete row").Rows("1:3").Delete

End Sub

but: deletes the hole rows, not only cells

[Gitano]

Hi all Dear Gamblers!
I need some help to create a excel sheet that show me some statistics for a new system/strategy I've invented.
The systems actually is very easy, it works on frequency in finals.

I explain for you the idea:

It is played consecutively and this is the issue I find in excel.

I wait 3 spins (or more if a final is repeated) where finals are different and wait a virtually win within 5 spins.( if no win I suppose the session vanish without betting)
Let's say for example we have 0,11,14,22,34 I waited 3 spins + 2 where I reached the virtually win with number 34.

so in terms of finals it is 0/1/4/2/4. Now that I discover the first win with the last "4" final, I start finally to bet all numbers with final 0,1,4 FOR maximum 3 times. I was checking with automatic airball spins..and it show more wins than losses increasing accuracy betting after a win session. 

I have already a file that search it but I am not able to do it consecutively, I mean, starting after the virtual win counting 3 different finals..
Can someone excel master do this ?

Thanks You very much.

Gitano

[Gitano]

Just to have the idea:

[Winner]

Hi all Dear Gamblers!
I need some help to create a excel sheet that show me some statistics for a new system/strategy I've invented.
The systems actually is very easy, it works on frequency in finals.

I explain for you the idea:

It is played consecutively and this is the issue I find in excel.

I wait 3 spins (or more if a final is repeated) where finals are different and wait a virtually win within 5 spins.( if no win I suppose the session vanish without betting)
Let's say for example we have 0,11,14,22,34 I waited 3 spins + 2 where I reached the virtually win with number 34.

so in terms of finals it is 0/1/4/2/4. Now that I discover the first win with the last "4" final, I start finally to bet all numbers with final 0,1,4 FOR maximum 3 times. I was checking with automatic airball spins..and it show more wins than losses increasing accuracy betting after a win session. 

I have already a file that search it but I am not able to do it consecutively, I mean, starting after the virtual win counting 3 different finals..
Can someone excel master do this ?

Thanks You very much.

Gitano

If it’s not vb or computers it won’t win ,just saying careful what you post if it’s mecanical system

[Gitano]

OK, I will be careful, but it's not Ballistic, it's only Visual..the visual of the ball landing on my finals

[ati]

Hi,
Could anyone help me out here?
I have two number sets in columns A and B, and at the bottom row where I have 10 and 3, I need a formula for column C that searches for the last occurrence of B in column B and returns the value of A.

A     B    C
11   3
2     1
7     2
10   3     here I'd like to see what was the last value of A when number 3 appeared in column B, in this example it should be 11

thanks

[Nickmsi]

Hi Ati,

If you arrange your columns from Left to Right per attached sheet you can use the VLOOKUP function as shown in the Yellow Cell.

Cheers

Nick

[Let Me Win]

Good to see you're still posting Nick.

Are you still working with VDW concepts or have you moved onto a new project now?

[Bigbroben]

If you arrange your columns from Left to Right per attached sheet you can use the VLOOKUP function as shown in the Yellow Cell.

Thanks for this VLOOKUP hint, did know it existed but never used it.

From what I can see it will find the first corresponding result in the column and will hold further down, right?  How to do to find the last occurence?   Relative OFFSET?

Thanks

[ati]

Hi Nick,
Thanks for your reply. My problem is what Bigbroben is asking, I need to find the last occurrence in a long series with lots of repeats. VLOOKUP only searches for the first.
Sorry my explanation wasn't clear.

I found the below formula on a forum. The row and column values would need to be adjusted for my sheet, but I couldn't get it work.

=INDEX(B$1:B$9,MATCH(MAX(IF($A$1:A1=A2,ROW($A$1:A1),0)),ROW($A$1:A1),0))

I'm not even sure what it would do, as I've never used some of these formulas.

[Nickmsi]

Hi Ati and  Bigbroben,

The Index Match function is one way to get the last occurence but I find it complicated. 

A more simple solution is just to use the Lookup function as shown in the attached sheet.  This will give you the last occurence.

Hi Let Me Win, yes I am working on both VDW and other projects as they present themselves,  I am always learning new ideas and love to test them out.  If you got something new, just let me know.

Cheers

Nick

[Bigbroben]

ATI,

What are the 2 columns you are trying to figure out?  Are they straight ups or other?

I could send you a sheet.

[Bigbroben]

Ati,

from the nrs you gave I suspect you are looking at streets and dozens.

Have a look at the sheet and tell me if you need modifications.

Simply enter the straight-up nrs in the F column.

Enjoy!

[ati]

This is what I was looking for. Thanks for both of you! 

from the nrs you gave I suspect you are looking at streets and dozens.

That's correct, those are streets and dozens.

I will try to implement this into my current test.