Results 1 to 6 of 6

Thread: Excel, :)

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    . . zeox's Avatar
    Join Date: Feb:2006
    Location:
    Posts: 3,716

    Excel, :)

    , 2-3
    :
    , .
    , ... .
    .
    - : , ... 2 sheet- 1 . .
    Find , .
    Lookup ?
    :EPOX MF4 Ultra-3#CPU: Athlon 64 X2 4600+ [Xigmatec HDT S963]#RAM: 21GB SuperTalent DDRII 800 CL4
    #video:GAINWARD 8800GS 384MB#PSU:COOLER MASTER RP M520#Monitor:HP P1100 1280x1024 @100Hz

  2. #2
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    =ISERROR(MATCH(B1;$A$1:$A$9;0))
    B1 -
    $A$1:$A$9 -
    FALSE
    TRUE
    ?

  3. #3
    Registered User bpk's Avatar
    Join Date: Feb:2008
    Location: xxx
    Posts: 9,979
    ISERROR, ISNA:
    - TRUE - ;
    - FALSE - .
    ISERROR - .
    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

  4. #4
    Registered User
    Join Date: Mar:2004
    Location: In your dreams
    Posts: 5,088
    , - conditional formatting, - . MATCH, VLOOKUP, COUNTIF .., 2007 ( ). .

  5. #5
    . . zeox's Avatar
    Join Date: Feb:2006
    Location:
    Posts: 3,716
    , , .

    @ven_stoich , .
    :EPOX MF4 Ultra-3#CPU: Athlon 64 X2 4600+ [Xigmatec HDT S963]#RAM: 21GB SuperTalent DDRII 800 CL4
    #video:GAINWARD 8800GS 384MB#PSU:COOLER MASTER RP M520#Monitor:HP P1100 1280x1024 @100Hz

  6. #6
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    , - ?
    MS Access
    SELECT * FROM moite_klienti, nomera_defektni WHERE moite_klienti.NomerDvigatel= nomera_defektni.NomerDvigatel

    ,

    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 |