Lottery ckeck in Excel

[bacalaoyalcapurria]

I have a spreadsheet with six columns "A,B,C,D,E,F" and 1000 rows. Numbers is all I have in each column

I'd like to be able to search for six numbers. For example, if I type in a cell the following numbers 1-25-33-53-29-7
I want Excel to tell me if those numbers exist within my existing data. (To look in the 6 columns)
Also, if those numbers don't exist, then, can Excel tell me if I have 2 or 3 or 4 or 5 of those numbers.
Can it be done? It's for a lottery check.

Thanks,

Rita

 

[GlennUK]

... if I type in a cell the following numbers 1-25-33-53-29-7

... what about typing the numbers in 6 different cells instead? Is that acceptable? A solution for that would be a lot easier.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[LievenV]

Hi,

I've made something like it in the past, but also in seperate cells. Wouldn't mind sending it to you, but I don't know how to do that through tek-tips. Don't really want to leave my e-mail address here.

 

[GlennUK]

Hi LievenV,

post your formulae and method on here for all of to benefit from. That's the whole point of this forum!

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[mintjulep]

Fairly simple using COUNTIF if you are willing to enter your ticket's numbers in separate cells.

Parsing out from single-cell entry wouldn't be difficult, but doesn't seem worth the trouble.