Results 1 to 11 of 11

Thread: :

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User maxee's Avatar
    Join Date: Oct:2004
    Location: .
    Posts: 50

    Thumbs up :

    .

    .

    :
    1. .2
    1 8 false
    2 9 false
    3 0 match
    4 3 false

    1 2. 3. .

    .

  2. #2
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    find - , Find, . find VBA.
    MATCH - worksheet function .

  3. #3
    . 's Avatar
    Join Date: Feb:2006
    Location: .
    Posts: 2,737
    1. , , 1 B1, C1 :
    Code:
    =IF(A1=B1;"";" ")
    2.
    Code:
    =IF(Sheet1!A1=Sheet2!A1;"";" ")
    1 1 1 2.
    - .

  4. #4
    Registered User entium's Avatar
    Join Date: May:2003
    Location:
    Posts: 1,426
    B
    =IF(ISNA(VLOOKUP(A1;B1:B4;1;FALSE));0;1)
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  5. #5
    Registered User maxee's Avatar
    Join Date: Oct:2004
    Location: .
    Posts: 50
    Quote Originally Posted by entium View Post
    B
    =IF(ISNA(VLOOKUP(A1;B1:B4;1;FALSE));0;1)
    ?

    "" "" ...


  6. #6
    Registered User entium's Avatar
    Join Date: May:2003
    Location:
    Posts: 1,426

    Smile

    Quote Originally Posted by maxee View Post
    ?

    "" "" ...

    VLOOKUP ( ) - #N/A. ISNA #N/A true. IF , , .
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  7. #7
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    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 |