D511
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 44 articles for 0.303 sec
"Joe Bruno" <jbruno@indystart.com> wrote in message news:207358f0-d511-4730-9488-de32b3f6ec70@l28g2000prd.googlegroups.com... On Jul 1, 7:03 pm, Sam Buckland <noth...@invalid.invalid> wrote: >> Topaz wrote: >> > By Mark Weber >> > Much has already been written about Roosevelt's campaign of deception >> >> That glue-sniffing habit of yours must be screwing with your >> short term memory.     

Group: alt.revisionism · Group Profile · Search for D511 in alt.revisionism
Author: Helge
Date: Jul 2, 2008 03:47

OK, you want to check for the existance of a product first, before you check for a price override. So change the If statement to: =IF(ISNA(VLOOKUP(E19,TABLE1A,3,FALSE)),"",IF(PRICEOVERRIDE!B2>0,PRICEOVERRIDE!B2,VLOOKUP(E19,TABLE1A,3,FALSE)) Regards, Fred "cjbarron5" <cjbarron5@discussions.microsoft.com> wrote in message news:37B4734D-D511-4D27-8BA3-DF2E0607BFD4@microsoft.com... well
Show full article (0.83Kb) · Show article thread
I owe everyone a big apology. The reason I was getting the odd 1 added was for a very silly reason. What I'd done was to do a count of 1's at the bottom of the sheet and hidden them, where I had only 1..1 then it would add that one to the final total. Where the total of 1's was greater or less than 1 it was ignored. I was jumping ahead of myself in trying to do as much as possible then adding     

Group: microsoft.public.excel.misc · Group Profile · Search for D511 in microsoft.public.excel.misc
Author: Fred Smith
Date: May 23, 2008 19:24

Not using the formula I posted and following the instructions I gave ... Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Bryan De-Lara" <bryan.delara123@btinternet.com> wrote in message news:u53Fc5VcIHA.5164@TK2MSFTNGP03.phx.gbl... Thanks Macropod, trouble is if I enter it into C row I get a circular problem. Bryan. "macropod" <invalid@invalid.invalid
Show full article (0.78Kb) · Show article thread
Thanks Bernard, =SUMPRODUCT(--(C1:C511=1),--(C2:C512<>1)) is entered in D1 which checks row C, then the formula advance one i.e. =SUMPRODUCT(--(D1:D511=1),--(D2:D512<>1)) which is entered in row E and so on right up to row DH. Trouble is it seems to be also adding the row before. Even if the row before is completely empty, I get a value of 1 in every reporting cell where the formula is. Very     

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: Bryan De-Lara
Date: Feb 18, 2008 00:13

If it is in C it cannot be anywhere in the ranges mentioned in the SUMPRODUCT. So it cannot be in C2:C513 Please stay with one thread -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bryan De-Lara" <bryan.delara123@btinternet.com> wrote in message news:u53Fc5VcIHA.5164@TK2MSFTNGP03.phx.gbl... Thanks Macropod, trouble is if I enter it
Show full article (2.97Kb) · Show article thread
Thanks Macropod, trouble is if I enter it into C row I get a circular problem. Bryan. "macropod" <invalid@invalid.invalid> wrote in message news:e1aTswVcIHA.6080@TK2MSFTNGP05.phx.gbl... > Hi Bryan, > > =SUMPRODUCT(--(C2:C512=1),--(C3:C513<>1)) > entered into C1 or D1 and copied across seems to work. > > Part of the problem you're having is that your formula references the > first     

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: macropod
Date: Feb 17, 2008 14:40

Hi Bryan, =SUMPRODUCT(--(C2:C512=1),--(C3:C513<>1)) entered into C1 or D1 and copied across seems to work. Part of the problem you're having is that your formula references the first row in the previous column and, if the formula in that cell returns a '1', its value gets added to the total for the next column. Cheers -- macropod [MVP - Microsoft Word] -------------------------
Show full article (2.29Kb) · Show article thread
I am still having problems counting blocks of 1's. A few are returning the correct values, but others are seem to be adding 1 from the previous column. The formula I'm using is.. =SUMPRODUCT(--(C1:C511=1),--(C2:C512<>1)) =SUMPRODUCT(--(D1:D511=1),--(D2:D512<>1)) =SUMPRODUCT(--(E1:E511=1),--(E2:E512<>1)) =SUMPRODUCT(--(F1:F511=1),--(F2:F512<>1)) =SUMPRODUCT(--(G1:G511=1),--(G2:G512     

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: Bryan De-Lara
Date: Feb 17, 2008 05:13

On Feb 9, 8:24 pm, eyeball <eyeball2002...@aol.com> wrote:> I converted an old testors T-6 (since it was gonna get cut up anyway) into a BT-14 and gave it the blue/yellow scheme in the (one of my favorite finished models) ,used another to do the NA-64> fighter.Then used the much better Heller and Academy kits to several more,all from that book.And have at least one or two more
Show full article (3.14Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: Bernard Liengme
Date: Feb 17, 2008 04:54

Show full article (2.39Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: Bryan De-Lara
Date: Feb 17, 2008 04:13

Show full article (1.97Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: macropod
Date: Feb 17, 2008 03:56

Show full article (1.69Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for D511 in microsoft.public.excel
Author: Bryan De-Lara
Date: Feb 17, 2008 02:31

Show full article (1.15Kb)
    

Group: rec.models.scale · Group Profile · Search for D511 in rec.models.scale
Author: maiesm72
Date: Feb 9, 2008 23:35

Show full article (2.05Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · next