Results 1 to 17 of 17

Thread: EXCEL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Aug:2010
    Location:
    Posts: 6

    EXCEL

    , ! !

  2. #2
    Registered User bpk's Avatar
    Join Date: Feb:2008
    Location: xxx
    Posts: 9,979
    , .
    ; .
    - .

    . / .
    24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600

  3. #3
    Registered User
    Join Date: Aug:2010
    Location:
    Posts: 6
    ! . . , . . ...

  4. #4
    Registered User bpk's Avatar
    Join Date: Feb:2008
    Location: xxx
    Posts: 9,979
    , .
    , -.
    1. , ( ).
    2. , "" .
    3. ( ).

    . ?
    24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600

  5. #5
    Registered User
    Join Date: Aug:2010
    Location:
    Posts: 6
    , , . , . , . !

  6. #6
    The Game Atlant's Avatar
    Join Date: Oct:2003
    Location: Tristram
    Posts: 2,984
    Quote Originally Posted by babazima View Post
    , , . , . , . !
    autofilter .
    .

  7. #7
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712
    Text To Columns ?
    !

  8. #8
    Registered User bpk's Avatar
    Join Date: Feb:2008
    Location: xxx
    Posts: 9,979
    Quote Originally Posted by babazima View Post
    , , . , . , . !
    ( F2 ) - , . .

    - , - . . .
    24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600

  9. #9
    Registered User
    Join Date: Aug:2010
    Location:
    Posts: 6
    ! ! !

    ---------- 23:12 ---------- 22:13 ----------

    , : ?

  10. #10
    The Game Atlant's Avatar
    Join Date: Oct:2003
    Location: Tristram
    Posts: 2,984
    Quote Originally Posted by babazima View Post
    ! ! !

    ---------- 23:12 ---------- 22:13 ----------

    , : ?
    Concatenate

    :
    http://www.techonthenet.com/excel/formulas/concat.php

  11. #11
    Registered User
    Join Date: Aug:2010
    Location:
    Posts: 6
    ? ...

  12. #12
    The Game Atlant's Avatar
    Join Date: Oct:2003
    Location: Tristram
    Posts: 2,984
    Quote Originally Posted by babazima View Post
    ? ...
    . .


    =Concatenate(A1, A2) would return "Alphabet"
    =Concatenate("Tech on the ", "Net") would return "Tech on the Net"
    =Concatenate(A1, "bet soup") would return "Alphabet soup"

  13. #13
    Registered User
    Join Date: Aug:2010
    Location:
    Posts: 6
    , ? !

    ---------- 00:36 ---------- 23:45 ----------

    ,

  14. #14
    Registered User
    Join Date: Jul:2006
    Location: Sofia
    Posts: 584
    .
    3
    =Concatenate(A1, A2) would return "Alphabet"
    Alphabet 1 + 2

  15. #15
    Registered User
    Join Date: Sep:2010
    Location:
    Posts: 13

    excel -

    ,

    , . . , . . . 5 . . .. 228. ( 5) . . lookup,IF . - - .

    , , - !

  16. #16
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    - Data Validation/List. .
    - Conditional Formatting.
    - SUMIF.
    , Excel .

  17. #17
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location:
    Posts: 1,058
    - .
    :
    Code:
    =SUBTOTAL(9;A1:A2)
    .
    ... , ,
    , ... ?

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 |