Hello I want from lotto draws (for example 100) create a formula ( or another way )which can find 4,5,6,7 … numbers that appears in every draw

For example there are 3 draws , 1 draw =123 2 draw =145 3 draw= 456 the formula must gives these output =145



How can I do it ? Im beggineer may someone writes the formula if it is easy

Or give me councils ? Thanks

Hi and welcome to the board.
Could you please add a small ample sheet with your data layout and expected result?

Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

hello thanks for your post .i send a sheet.

Attached Files

extra5_2011 (2) (1) (1).xls (183.5 KB, 15 views)

I still don't see an example pointed out on your sheet of what you're trying to automate.

I was thinking initially a COUNTIF() formula to tell you how many times the number 4 was drawn? =COUNTIF(D:H, 4)

Perhaps a smaller sheet with less data where you could easily write up your desired results manually so we see what you're after more clearly??