Results 1 to 3 of 3

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User brnn's Avatar
    Join Date: Jun:2006
    Location:
    Posts: 754

    Excel

    , , Data e range- ( ) :

    Code:
    =OFFSET('123'!$C$9;0;0;COUNTA('123'!$C:$C)-1)
    =OFFSET('123'!$G$9;0;0;COUNTA('123'!$G:$G)-1)
    . , , . , , , (.. ""). - ( ), , .

    , : "" , , ? "", ( ). :

    Code:
    =IF(NOT(ISBLANK(E359));G358+E359;"")
    !

    : COUNTIF, .
    Last edited by brnn; 30th August 2015 at 16:55.

  2. #2
    Outcast DeathKnight's Avatar
    Join Date: Jul:2003
    Location:
    Posts: 1,772
    .. :
    - .
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	sbit.jpg‎ 
Views:	100 
Size:	58.0 KB 
ID:	77826  
    Last edited by DeathKnight; 1st September 2015 at 09:49.
    , , template Adwords , firewall-a , ... <template>

  3. #3
    Registered User brnn's Avatar
    Join Date: Jun:2006
    Location:
    Posts: 754
    ! COUNTIF - -1 000 000. , .. , , 100 , 15, 100 , 15-.
    Last edited by brnn; 1st September 2015 at 16:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |