Results 1 to 7 of 7

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jan:2008
    Location:
    Posts: 1,852

    Excel

    ,

    , , 7500 . ( )


    1
    1
    2
    3
    4

    2
    1
    2

  2. #2
    -==-
    Join Date: Sep:2003
    Location:
    Posts: 6,444
    . . ?
    He who asks is a fool for five minutes, but he who does not ask reamins a fool forever. Old Chinese saying
    Quote Originally Posted by worm4 View Post
    a .

  3. #3
    Registered User
    Join Date: Jan:2008
    Location:
    Posts: 1,852
    . 1 (1) (B1), 2 , 90% 1. 1 1 B1 2 B1.

    , B1 1 2.

  4. #4
    ForumFootballClub Member Zabluden's Avatar
    Join Date: Dec:2003
    Location: Sofia
    Posts: 4,570
    VLOOKUP , .
    1. MATCH ( ). "" .
    2. CONCATENATE (=concatenate("=sheet1.b";[ .1]). - .
    3. "=sheet1.bX", "paste special - text" , find-replace "." "." () , .

    - . VLOOKUP- , . ( ). ""
    It's not about what science can do for you. It's all about what you can do for the science.

    ignore list:Zabluden

  5. #5
    Registered User
    Join Date: Jan:2011
    Location: Sofia
    Posts: 48
    Vlookup range_lookup 1 true.

    =vlookup(" ";" ";" ";" ")
    !
    Last edited by jorkoto; 16th July 2015 at 15:43.

  6. #6
    The point of no return ifch0's Avatar
    Join Date: Jun:2007
    Location:
    Posts: 3,678
    VLOOKUP?

    Click image for larger version. 

Name:	Clipboard01.jpg 
Views:	39 
Size:	60.7 KB 
ID:	76794

    . "FALSE" Exact Match.
    Last edited by ifch0; 4th July 2015 at 13:13.
    , , , .
    : ( ) - (); (..) - (..).
    -----! , ...

  7. #7
    Registered User
    Join Date: Jul:2004
    Location:
    Posts: 621
    Google Spreadsheets =DGET(Sheet1!A:B, "", {""; A1}) B1 . Excel

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 |