Is it possible to find multiple data?

S

stewwie

We have a small lotterysyndicate in work which is all logged onto an
excel spreadsheet. Is it possible to search all numbers and all
occurances at once, rather than individually?

Ie - we have 15 lines of 6 numbers each - can i search for all 6
numbers drawn, across all 15 lines in one go?

Im sure this must be possible - just dont know how.

Thanks
 
S

stewwie

Thats the type of thing - just tested it with our lines and works well -
only problem is, I cant save it
 
S

stewwie

I was doing copy and paste - but it wasnt copying the formulas
properly.... It did with paste special though

Thanks again
 
Top