Results 1 to 2 of 2

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User ogun's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 3,936

    Excel

    ,
    , .

    2 :

    1:


    2:


    , .. . 1 2, 2 1 . 1 , 2, .

    1 2 2 . , .

    , , .


    !
    .

  2. #2
    Registered User
    Join Date: May:2005
    Location:
    Posts: 933
    , .

    1- -
    ( 1 - , 2 - ), VLOOKUP. = (VLOOKUP( )* )


    2- -
    Excel 2013 > DATA > Relationships (- MS Access, SQL)
    Primary Key . " 1" " 2".

    3- - (array)
    Excel array. Ctrl + Alt + Enter. {=}

    =IF, EXIST, VLOOKUP




    -, . . - .

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 |