| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking Lotto numbers
Numbers to be checked - A4:F10
Draw numbers - A12:F12 I have tried (in I4) {=IF($A4:$F4=A12,"P","")} which works but only because the criteria is met in the first column. When copied down and accross it doesn't work. Any ideas? -- tia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lotto template | New Users to Excel | |||
| Checking numbers across various sheets | Excel Worksheet Functions | |||
| uk lotto dream numbers | New Users to Excel | |||
| Checking crossword numbers | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Threaded Mode
