| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lottery
agai brilliant thanks for all the advice
"Mike H" wrote: Hi, Counting the colours is possible but this is simpler. Put the formula at the end of each row and drag down =SUMPRODUCT(--ISNUMBER(MATCH(A4:F4,$A$1:$F$1,0))) Mike "smason" wrote: briliant can i calculate a 'red cell' to say i.e three cells =3 "Mike H" wrote: Hi, Select the 6 columns and as many rows as you have lines (Mine start in A4 so change to suit) and then Format|Conditional format Select formula is and enter the formula =COUNTIF($A$1:$F$1,A4)0 Pick a colour and OK. Mike "smason" wrote: yes sorry say i have the lotto numbers for that weeks draw i.e. a1 b1 c1 d1 e1 f1 1 4 23 44 6 12 and these are my numbers each week that i want to check (same columns) 1 5 30 45 30 22 4 9 44 15 48 10 etc i want my numbers to go red if they correspond with the drawn number hope this helps "Mike H" wrote: Hi, I think you need to explain a bit more. In most lotteries (I think) you only pick 6 numbers. What do you want highlighting and where? How do we get to 4 rows of numbers or more from 6 numbers? Mike "smason" wrote: Hello i want to create a spread where i input the 6 lottery number into say a1 b1 c1 etc and have my list of lottery numbers (4 rows of numbers or more) highlight red (or what ever colour) any ideas |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lottery
Glad I could help
"smason" wrote: agai brilliant thanks for all the advice "Mike H" wrote: Hi, Counting the colours is possible but this is simpler. Put the formula at the end of each row and drag down =SUMPRODUCT(--ISNUMBER(MATCH(A4:F4,$A$1:$F$1,0))) Mike "smason" wrote: briliant can i calculate a 'red cell' to say i.e three cells =3 "Mike H" wrote: Hi, Select the 6 columns and as many rows as you have lines (Mine start in A4 so change to suit) and then Format|Conditional format Select formula is and enter the formula =COUNTIF($A$1:$F$1,A4)0 Pick a colour and OK. Mike "smason" wrote: yes sorry say i have the lotto numbers for that weeks draw i.e. a1 b1 c1 d1 e1 f1 1 4 23 44 6 12 and these are my numbers each week that i want to check (same columns) 1 5 30 45 30 22 4 9 44 15 48 10 etc i want my numbers to go red if they correspond with the drawn number hope this helps "Mike H" wrote: Hi, I think you need to explain a bit more. In most lotteries (I think) you only pick 6 numbers. What do you want highlighting and where? How do we get to 4 rows of numbers or more from 6 numbers? Mike "smason" wrote: Hello i want to create a spread where i input the 6 lottery number into say a1 b1 c1 etc and have my list of lottery numbers (4 rows of numbers or more) highlight red (or what ever colour) any ideas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lottery combinations | Excel Worksheet Functions | |||
| Lottery Model | Excel Worksheet Functions | |||
| Lottery check | New Users to Excel | |||
| Lottery exercise | Excel Worksheet Functions | |||
| lottery drawing | Excel Worksheet Functions | |||
Hybrid Mode
