detect each corresponding number of the draw line.

detect each corresponding number
of the draw line
goal = is to locate each number within the group
* 01 to 25 of the yellow band
https://www.excelforum.com/attachmen...1&d=1563900688

let me see if i can understand what it is that you want done. looking at this now.

so question on your workbook. in cell AI5, you have an x, but the data in row 5 does not match that. was this a mistake or intended?

ok sorry DMC it was a mistake
you must delete the markup
* at number 19 because it's not in the draw line,
the yellow line has been placed in the order
* vertical i already have in horizontal order
01 02 03 04 05
* this work is vertically = 01 06 11 16
21
my goal is to cross cracks in the Cartezian
* you have to detect every number
* correspondingly, there was an error at number 19

so i have the code to put the "x" in the correct spot. just need the count at the end and i will post.

thanks ALI but the macro
* no good, another macro has to be done

hello,ALI
error=
01 06 11 16 21 02 07 12 17 22 03 08 13 18 23 04 09 14 19 24 05 10 15 20 25 sum
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 15
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 16
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 17
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 18
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 19
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 20
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 21
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 22
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 23
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 24
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 25
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 26
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 27
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 28
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 29

ok that's ok congratulations my windows is 64 bit my excel 2016
thank you!!! ALIGW, ok

i know this thread is solved, but took awhile to get my solution working. with some help from stackoverflow, this now works. interestingly enough, all the sums are 15.

Sub mark_x()
    Dim wb     As Workbook
    Set wb = ThisWorkbook
    Dim ws     As Worksheet
    Set ws = wb.Sheets("Planilha1")
    Dim x      As Long, y As Long, z As Long
    Dim LastRow As Long
    LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
    For z = 5 To LastRow
        For x = 1 To 15
            If Cells(5, x) < 10 Then
                Debug.Print "data is " & "0" & Cells(5, x)
            Else
                Debug.Print "data is " & Cells(5, x)
            End If
            For y = 17 To 41
                If Cells(z, x) = Cells(4, y) Then
                    Cells(z, y).Value = "x"
                End If
            Next y
        Next x
        Cells(z, 42).Formula = "=CountIf(Q" & z & ":AO" & z & "," & """x"")"
    Next z
End Sub

hello, DMC, thanks for completing the macro, it's working fine, it's always nice to have two different opinions
of course the sum always has to be 15 because my
* lottery (one of them) is 25/15 ie the draw is 15 numbers, must be 15 markings (x)
* goal = is full and empty crack sequences
* by columns and so you can see patterns,
* When will winning any prize be rewarded? thanks DMC

great, if you need any more help, let me know.

ALIGW, thank you!! THINK POSITIVE
everything is 80/20.
if you have focus is 80 and not 20

"There is no such thing as luck, the divine Jew, etc. just adequate or inadequate preparation for dealing with a statistical universe."
of course i agree that a starting point is missing
* or base or a reference for not circling, but math can help a little with smaller prizes and the big prize comes from the ride, we haven't learned enough yet
* to go mathematically to some extent, I agree that 100% control will never have, but prizes
* small.