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
|