Elf Email
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
Dalek Dave wrote:
I listen to my staff, for with their acquiescence life is easier
Just sayin'.
It was broke, so I fixed it.
-
Dalek Dave wrote:
I listen to my staff, for with their acquiescence life is easier
Just sayin'.
It was broke, so I fixed it.
He listened - then he beat the elf.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
-
He listened - then he beat the elf.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."
Then listen some more while the elf screamed in fear, I fear.
It was broke, so I fixed it.
-
-
You mean this plexyglass cover for the bus and the expansion boards? And here is a screenshot[^] of the test program for the graphics chip. I remember typing it in and running it after soldering the computer together.
"Dark the dark side is. Very dark..." - Yoda ---
"Shut up, Yoda, and just make yourself another toast." - Obi Wan Kenobi -
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
No programming questions! :-D Do not beat Elf too hard as you may need them later.
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
Looks a quite reasonable question to me. I thought you were the god of Excel? ;)
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
Dalek Dave wrote:
Off to beat Elf!
Surely you mean bishop?
Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
-
Looks a quite reasonable question to me. I thought you were the god of Excel? ;)
-
Dalek Dave wrote:
Off to beat Elf!
Surely you mean bishop?
Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
its obvious, the second one doesnt know were it is. so any results are floating about looking for directions you need to tell them they are in Nuneaton or some poor bugger in Leamington Spa will sudenly get a load of excel apearing on sceen
You cant outrun the world, but there is no harm in getting a head start Real stupidity beats artificial intelligence every time.
-
He listened - then he beat the elf.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."
-
Just had this come in... Why is this working: {=COUNT(IF(Nuneaton!$A$2:$A$2404=J2,IF(Nuneaton!$F$2:$F$2404>0,Nuneaton!$F$2:$F$2404)))} But this isn't: {=COUNT(IF('Query Import'!A1:A3004=A3,IF('Query Import'!B1:B3004="LSN",'Query Import'!B1:B3004)))} That's it, no reference, no message, no nothing! Off to beat Elf!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
No programming questions in the Lounge Dave. Tsk, tsk, tsk.
¡El diablo está en mis pantalones! ¡Mire, mire! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Personal 3D projects Just Say No to Web 2 Point Blow
