Home |
Search |
Today's Posts |
#1
|
|||
|
|||
reading blank cell as active - how can I stop it ?
W2k + MSO2K3
lookup - a problem - I am checking winning lotto numbers against a (losing) selection -, i am using a lookup table, and also count if function to determine how many wins are acheived in each row. The problem is: 1... Still waiting to win Jackpot - well win anything would be nice 2. When the `Drawn Numbers` and User Selection Range/s are left blank, the lookup table reflects it is a win , I have tried to incude a blank cell with in table but that does not register as a `nil` =IF(LEN(E27)0,IF(ISERROR(VLOOKUP(E27,drawn,2,FALS E)),"nil",VLOOKUP(E27,draw n,2,FALSE)),"") Please always reply to the group, - KNOWLEDGE IS FOR SHARING --- sorry for shouting.. |
#2
|
|||
|
|||
You may like this better where the winnning list is on row 5 and yours on
row 6 =IF(F6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5))) -- Don Guillett SalesAid Software "Nu-bEE" wrote in message ... W2k + MSO2K3 lookup - a problem - I am checking winning lotto numbers against a (losing) selection -, i am using a lookup table, and also count if function to determine how many wins are acheived in each row. The problem is: 1... Still waiting to win Jackpot - well win anything would be nice 2. When the `Drawn Numbers` and User Selection Range/s are left blank, the lookup table reflects it is a win , I have tried to incude a blank cell with in table but that does not register as a `nil` =IF(LEN(E27)0,IF(ISERROR(VLOOKUP(E27,drawn,2,FALS E)),"nil",VLOOKUP(E27,draw n,2,FALSE)),"") Please always reply to the group, - KNOWLEDGE IS FOR SHARING --- sorry for shouting.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Woorksheet locked on active cell | Excel Worksheet Functions | |||
stop cell entry being copied to other cell | Excel Worksheet Functions | |||
Ghost Blank Cell References | Excel Worksheet Functions | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Unable to set the active cell from VBA | New Users to Excel |