Results 1 to 9 of 9

Thread: excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Apr:2007
    Location: Sofia
    Posts: 172

    excel

    ,

    -advanced xcel ?
    : 800 user-a. ( 30) ( ), users. user . 800 ​ / , 1 1. /.

    vlookup .

    !

  2. #2
    Registered User
    Join Date: May:2009
    Location:
    Posts: 1,291
    ( 4-5 ),

  3. #3
    Registered User
    Join Date: Apr:2007
    Location: Sofia
    Posts: 172
    users, (group1, group2...). users /( ) (group...), . B C, Group 1 Group 2.

    .

  4. #4
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    .
    ( , , ):
    Code:
    	alfa	beta	gamma
    an	bob	charles	an
    bob	an	an	charles
    charles		bob
    :
    Code:
    =IF(ISNA(VLOOKUP($A2;B$2:B$50;1;0));"---";B$1)
    , :
    Code:
    an	
    bob	
    charles
    .
    :
    Code:
    an	alfa	beta	gamma
    bob	alfa	beta	---
    charles	---	beta	gamma
    , ("---").

  5. #5
    -==-
    Join Date: Sep:2003
    Location:
    Posts: 6,444
    , Exel. - , .
    Last edited by Yasen6275; 12th June 2017 at 18:20.
    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 .

  6. #6
    Registered User
    Join Date: May:2009
    Location:
    Posts: 1,291
    Quote Originally Posted by Yasen6275 View Post
    , Exel. - , .
    ! , VBA ( ),
    : : " - Exel"? : " , , "

    - - - - - -

    @gnb, . , . , Sheet2 . User-a

  7. #7
    Red Devil Jackxxx's Avatar
    Join Date: Oct:2011
    Location: Plovdiv
    Posts: 675
    ,

    , EXCEL .

    - "4", "Technician".

    COUNTIFS, 6 . . COUNTIFS .

    - ?
    Tomahawk B450 Max II | Ryzen 5 3600 | GTX970 | Ballistix 2x8Gb 3200 Mhz | Evo 970 500GB + 2TB TOSHIBA | Meshify C | Leadex II 650W | LG 27GL850 | Solo 7C
    Ducky One 2 + SS Rival 310
    The team that gets me excited is MANCHESTER UNITED!

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 |