Results 1 to 5 of 5

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Back2Business Bennett's Avatar
    Join Date: Oct:2008
    Location:
    Posts: 379

    Excel

    , . , E6 ( 0 9) G6 ( 0 5) D10 : D14, .. 6=1, G6=3, 4.

    Click image for larger version. 

Name:	untitled.JPG 
Views:	76 
Size:	26.8 KB 
ID:	65281
    Laptop .....

  2. #2
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    - - D, D10: =A10+C10*10 .

  3. #3
    Back2Business Bennett's Avatar
    Join Date: Oct:2008
    Location:
    Posts: 379
    , 6 , G6 , .
    Laptop .....

  4. #4
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    Quote Originally Posted by Bennett View Post
    , 6 , G6 , .
    - .

  5. #5
    Registered User
    Join Date: Feb:2011
    Location: Varna
    Posts: 12
    , , :
    Click image for larger version. 

Name:	excel.jpg 
Views:	53 
Size:	114.4 KB 
ID:	65322

    :
    =INDEX($D$10:$D$14,MATCH(E6&"|"&G6,$A$10 :$A$14&"|"&$C$10:$C$14,0))

    , array formula, .. Enter, Ctrl + Shift + Enter
    .


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 |