Results 1 to 25 of 27

Thread: ! Excel. VB

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9

    ! Excel. VB

    :

    Sheet1 A1 A2 drop down . .
    Sheet 2 , , B .
    : , Sheet 1 drop down ( ) B2 Sheet 1 ( ).

    , , . .

  2. #2
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317

  3. #3
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9
    DSUM, ?!?

    ---------- 12:49 ---------- 12:02 ----------

    , , .
    Last edited by computerangel; 30th October 2009 at 12:23.

  4. #4
    Modderhead
    Join Date: Nov:2005
    Location:
    Posts: 4,469
    -

    =SUMIF(< >;"<="& ;< >)

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	excel-sumif.JPG‎ 
Views:	1301 
Size:	21.0 KB 
ID:	24806  

  5. #5
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9
    . , - .

    SHEET 2
    2-

    SHEET 1


    : : 39 - 43 39/40/41/42/43 .
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Untitled.jpg‎ 
Views:	260 
Size:	52.4 KB 
ID:	24808  

  6. #6
    Modderhead
    Join Date: Nov:2005
    Location:
    Posts: 4,469
    , , , !!!

    : <=43 - () <39 . !

  7. #7
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    Quote Originally Posted by computerangel View Post
    . , - .

    SHEET 2
    2-

    SHEET 1


    : : 39 - 43 39/40/41/42/43 .
    Sheet1, "Weekly" ( F32:G45). Sheet2 C33:C34 Data\Validation, Allow: List, Source: =INDEX(Weekly;;1).
    D33 :
    Code:
    =SUM(OFFSET(Weekly;MATCH(C33;INDEX(Weekly;;1);0)-1;1;MATCH(C34;INDEX(Weekly;;1);0)-MATCH(C33;INDEX(Weekly;;1);0)+1;1))
    - , .



    Quote Originally Posted by knobel View Post
    , , , !!!

    : <=43 - () <39 . !
    , ("43\9" > "30\10").

  8. #8
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    (Weekly )? , ( Evaluate Formula toolbar Formula Auditing). , ( ), Name Box ( ) Enter. MS Excel 2003, .

  9. #9
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9
    . Avis.

    ---------- 16:38 ---------- 16:37 ----------

    . .

  10. #10
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9
    .

    Range "DB"
    , . GA,RZ,RS,SH,SS VT Weekly range-. DB , . .
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2.jpg‎ 
Views:	102 
Size:	91.7 KB 
ID:	24822  

  11. #11
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    , - ( A2:I9) (.. ";1;" ";2;" GA, ";3;" RS ..). , "Weekly" , 0, "INDEX(Weekly;;1)" "W" (W , .. A2:A9). - ("MATCH(" "MATCH($"), - .

  12. #12
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9
    , VALUE

    ---------- 12:17 ---------- 12:15 ----------

    W GA ?
    =SUM(OFFSET(W;MATCH(K5;INDEX(W;;2);0)-1;1;MATCH(K6;INDEX(W;;2);0)-MATCH(K5;INDEX(W;;2);0)+1;1))

    ---------- 12:21 ---------- 12:17 ----------



    =SUM(OFFSET(W;MATCH(K5;INDEX(W;;1);0)-1;2;MATCH(K6;INDEX(W;;1);0)-MATCH(K5;INDEX(W;;1);0)+1;1))


  13. #13
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9
    :

    , . vlookup, .
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Untitled111.jpg‎ 
Views:	111 
Size:	57.9 KB 
ID:	24919  

  14. #14
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    : - ..? 4 . , 3 , .
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  15. #15
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    MS Access?

  16. #16
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    asp.net + Mssql php+mysql -
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  17. #17
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    /on-topic
    vlookup . "W" . :
    - ;
    - ( );
    - ;
    - ( );
    - , , indirect;
    - VBA.
    , .

  18. #18
    Registered User
    Join Date: Oct:2009
    Location: Ruse
    Posts: 9

    :)

    , .

    . ( ) .
    =SUM(OFFSET(raz;MATCH(B233;INDEX(raz;;1) ;0)-1;2;MATCH(C230;INDEX(raz;;1);0)-MATCH(B233;INDEX(raz;;1);0)+1;1))
    #n/a. C230 s B233 , , 1 . , .

    .
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	123.jpg‎ 
Views:	101 
Size:	77.9 KB 
ID:	26924  

  19. #19
    chuck norris primetime's Avatar
    Join Date: Jan:2003
    Location: Sofia
    Posts: 4,715
    VLOOKUP. , .
    I can be friendly when I desire to. Alas, the desire to be more intelligent does not make it so.
    ... - :/

  20. #20
    Registered User
    Join Date: Sep:2010
    Location:
    Posts: 13

    Lightbulb EXCEL 2007

    ,
    :
    G2 - ,
    , 20-2 , 18
    J2 18. , G2 ,

    2. , ,
    3.
    4. C2 - 2 D2 , 1 1,50

    vllookup , , - .. .

    ,

    if and, . :
    -if(and(D2=),(E2=)),2,if(and(D2= ),(E2=)),1,if(and(D2=),(E2 =)),1,50,0)

    , ?



    !
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	kazus.JPG‎ 
Views:	62 
Size:	60.5 KB 
ID:	42661  
    Last edited by red_gendo; 16th September 2011 at 09:01.

  21. #21
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    - if(and(D2="") "" $H$1 ..

    ... vba -. ? , -
    , , , ,

  22. #22
    Registered User
    Join Date: Sep:2010
    Location:
    Posts: 13

    Lightbulb

    Quote Originally Posted by View Post
    - if(and(D2="") "" $H$1 ..

    ... vba -. ? , -
    vba , ( ) . vba . - , . , ! . , vba - , . vba , . VBA , . , .

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 |