I want find numbers repetition in lottery list

[febausa]

Please help in excel formula.

I want find numbers repetition (double and triple numbers hit/win) in historic lottery list.

 

[Joe4]

I don't know as use this formula for find double and triple repetition of hit or win.

Do you just mean which numbers show up more than once or something else?
If something else, please explain.

If you just want to highlight which number show up more than once, just use Conditional Formatting to highlight the COUNTIF formulas where the value returned is greater than one.

 

[shahfahad]

Try This:

CTRL + SHIFT + ENTER (Highlight 3 cells in advance and then CTRL+SHIFT+ENTER

=IF(ROWS(B$22:B22)>COUNT(MODE.MULT($K$4:$K$21)),"",MODE.MULT($K$4:$K$21))