???? ???????: 213367 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ????? ?????????? ???????? ??? ???????? ???????? ?? ?????? ????? ??? ?? ?????? Microsoft Excel ??????? ??? ????????? ????????.

??????? ????

??????? ??????: ??????? ???? ???? ???

???????? ???? ???? ??? ??????? ???????? ???????? ?? ??????? ???? ??????? ???????:
  1. ?? ?????? Excel.
  2. ?? ???? ??? ?????? ???? ???????? ??????? (???? ?????? B ??????):
    A1: 1   B1:     C1: 3
    A2: 2   B2:     C2: 5
    A3: 3   B3:     C3: 8
    A4: 4   B4:     C4: 2
    A5: 5   B5:     C5: 0
    					
  3. ???? ?????? ??????? ?? ?????? B1:
    ?=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)?
  4. ??? ??????? B1:B5.
  5. ?? Microsoft Office Excel 2003 ??? ????????? ??????? ?? Excel? ??? ??? ????? ?? ??????? ?????? ?? ???? ??? ??? ??????.

    ?? Microsoft Office Excel 2007? ???? ??? ????? ?? ???????? ?????? ?? ???? ??? ??? ??????.

    ??? ??? ??????? ???????? ?? ?????? B? ??? ?? ?????? ??????:
       A1: 1   B1:     C1: 3
       A2: 2   B2: 2   C2: 5
       A3: 3   B3: 3   C3: 8
       A4: 4   B4:     C4: 2
       A5: 5   B5: 5   C5: 0
    					

??????? ???????: ??????? ????? Visual Basic

???? Microsoft ??????? ???????? ???? ??????? ???? ??? ?? ???? ???? ?? ????. ?????? ???? ??? ???? ?????? ?? ?????? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ??? ????? ??? ??? ??????? ???? ??? ????? ???????? ????????? ?????? ????????? ????????. ???? ??????? ????? ??? Microsoft ??? ????? ????? ????. ??? ????? ?? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ???????? ???????? ??????. ???????? ????? Visual Basic ??????? ???????? ?? ??????? ?????? ??????? ??????? ?? ?????? ??????:
  1. ?? ?????? Excel.
  2. ???? ALT+F11 ???? ????? ???? Visual Basic.
  3. ?? ??????? Insert (?????)? ???? ??? Module (???? ?????).
  4. ???? ???????? ???????? ??????? ?? ???? ???? ?????:
    Sub Find_Matches()?
        Dim CompareRange As Variant, x As Variant, y As Variant
        ?' Set CompareRange equal to the range to which you will
        ?' compare the selection.?
        Set CompareRange = Range("C1:C5")?
        ?' NOTE: If the compare range is located on another workbook
        ?' or worksheet, use the following syntax.?
        ?' Set CompareRange = Workbooks("Book2"). _?
        ?'   Worksheets("Sheet2").Range("C1:C5")?
        ?'
        ?' Loop through each cell in the selection and compare it to
        ?' each cell in CompareRange.?
        For Each x In Selection
            For Each y In CompareRange
                If x = y Then x.Offset(0, 1) = x
            Next y
        Next x
    End Sub
    					
  5. ???? ALT+F11 ?????? ??? ?????? Excel.
  6. ???? ???????? ??????? (???? ?????? B ??????):
    A1: 1   B1:     C1: 3
    A2: 2   B2:     C2: 5
    A3: 3   B3:     C3: 8
    A4: 4   B4:     C4: 2
    A5: 5   B5:     C5: 0
    					
  7. ??? ?????? A1:A5.
  8. ?? Excel 2003 ??? ????????? ?????? ?? Excel? ??? ??? ????? ?? ??????? ?????? ?? ???? ??? ????? ?????.

    ?? Excel 2007? ???? ??? ????? ??????? ??????? ?? ???? ??? ????? ??????? ?? ?????? ??????? ??????.
  9. ???? ??? Find_Matches (?????? ??? ???????)? ?? ???? ??? ?????.
??? ??? ??????? ???????? ?? ?????? B. ???? ??? ??????? ???????? ????? ?????? ?????? ??? ?? ???? ???:
   A1: 1   B1:     C1: 3
   A2: 2   B2: 2   C2: 5
   A3: 3   B3: 3   C3: 8
   A4: 4   B4:     C4: 2
   A5: 5   B5: 5   C5: 0
				

???????

???? ???????: 213367 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 4.1
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
????? ??????: 
kbhowto kbprogramming kbdtacode KB213367

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com