Results 1 to 16 of 16

Thread: Excel.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165

    Excel.

    , Excel, , :

    EXCEL? , "" 4, . "", , 4. . , ?

    , , . :
    "" xcel , . "" xcel .

    , - , Excel. !
    believing

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

  3. #3
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    Quote Originally Posted by 0wn3r View Post
    , Excel, , :

    EXCEL? , "" 4, . "", , 4. . , ?

    , , . :
    "" xcel , . "" xcel .

    , - , Excel. !
    .
    , 1 .
    , , - 4.

    :
    .
    , - 1, . 1 .
    , .
    .. "" , "".

    ?
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  4. #4
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165
    Quote Originally Posted by bsb View Post
    HLOOKUP VLOOKUP. , . ,
    , . .

    Quote Originally Posted by feersum View Post
    .
    , 1 .
    , , - 4.

    :
    .
    , - 1, . 1 .
    , .
    .. "" , "".

    ?
    , , . "" 4. ? , "" ""?
    believing

  5. #5
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    Quote Originally Posted by 0wn3r View Post
    , , . "" 4. ? , "" ""?
    , , . . - 1, 4.
    1 , 4 . , .

    .

    :
    1 , 4.
    "", .

    2 3 .
    2 =1*3, =*3, 12.
    , , -, .
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  6. #6
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    - .
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	portokal.jpg‎ 
Views:	98 
Size:	163.6 KB 
ID:	31383   Click image for larger version. 

Name:	portokal2.jpg‎ 
Views:	102 
Size:	164.0 KB 
ID:	31384  
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  7. #7
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165
    ! . .
    believing

  8. #8
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    ! , .
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  9. #9
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165
    ? .
    believing

  10. #10
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    , .
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  11. #11
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165
    , , , . :

    , :

    :
    :
    :

    , , . , 1800. - asd12gh. , , asd12gh, 4. 1800/4 - , .

    , - , .

    .
    believing

  12. #12
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    . - A1. - A2. - A3.
    B , C .
    A3 =VLOOKUP(a2,b:c,2,false)
    , ";".

  13. #13
    a.k.a. Bibi Flower's Avatar
    Join Date: Aug:2006
    Location: Sofia, Bulgaria
    Posts: 562
    :

    .
    H1 - ..

    .
    - Data Source, - , . , a A1 .
    1 =INDIRECT(A1), , H1.
    INDIRECT() .

    2 , A1, B1 =INDIRECT(A1)/INDIRECT(B1).

    " " ( Data Source), .
    Last edited by Flower; 22nd July 2010 at 01:45.

  14. #14
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165
    Quote Originally Posted by Flower View Post
    ...
    a bsb . .
    believing

  15. #15
    user-friendly 0wn3r's Avatar
    Join Date: Mar:2006
    Location: Bulgaria,Plovdiv
    Posts: 1,165
    , .

    , , .

    :
    A B, VLOOKUP IF- , . , B1 VLOOKUP(A1, Sheet2!B:C,2, false), IF- . B2 , lookup_value 2. .

    , , . , B100 VLOOKUP(A100,...). , lookup_value vlookup B999 A999 . , excel , .

    , . .

    :

    , copy/paste. , . . 1 . 1, . , B 100, 101 vlookup(a101, !sheet2, b:c, false).
    Last edited by 0wn3r; 5th August 2010 at 20:18.
    believing

  16. #16
    Registered User
    Join Date: Jul:2006
    Location: Sofia
    Posts: 584
    paste - . .

    , 2010 .

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 |