????? ??????? ????? ??????? ???? ???????? ?? ????? ?????? ????? ???? ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 247311 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? ??? Microsoft Excel ????? ????? ???? ???? ????? (snaking) ????????. ????? ??? ??????? ??? ????? ????? ???? ???????? ?? ????? ???? ?????.

??????? ????

???? Microsoft ??????? ???????? ??? ??? ?? ???? ??????? ?? ?? ?????. ??? ????? ???? ?? ????? ??? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ???? ?????? ?? ??? ??????? ???? ??? ????? ?? ??????? ???? ??? ????????? ?????? ?????? ?????????. ???? ??????? ????? ??? Microsoft ??? ????? ????? ???? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ?????? ??????? ?????.

??? ???????

?? Microsoft Excel ????? ??????? ???? "???" ???? ?????. ????? ?? Excel ?? ????? ?? ???? ???? ????? ???? ????? ??? ?????? ??? ??? ?????? ????? ?????? ?????? ?? ?????? ?? ????? ??????? ?????? ??????. ????? ??????? ????? ?????? ?????? ???? ???? ?? ?? ????? ? ????? ??????? ??????. ???? ????? ?? ??????? ??? ????? ?????? ??????? ? ??? ???? ??????:
   A1: Q1   B1: Q2   C1: Q3
   A2: 10   B2: 2    C2: 4
   A3: 14   B3: 18   C3: 9
   A4: 7    B4: 17   C4: 12
   A5: 1    B5: 13   C5: 5
   A6: 11   B6: 8    C6: 16
   A7: 3    B7: 6    C7: 15
				
??? ??? ???? ??? ??????? ?? ????? ?????? ?????? Q1 ????? (?????? A) ? ????? ??????? ??? ???:
   A1: Q1   B1: Q2   C1: Q3
   A2: 1    B2: 13   C2: 5
   A3: 3    B3: 6    C3: 15
   A4: 7    B4: 17   C4: 12
   A5: 10   B5: 2    C5: 4
   A6: 11   B6: 8    C6: 16
   A7: 14   B7: 18   C7: 9
				

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

????? ????? ???????? snaking ???? ?????? ??? ??? ????? ????????. ?? ????? ????? ???????? ?????? ???? ???? ?? ????? ?? ???? ?????? ??????. ?? ??? ??????? ???????? ???? ?? ??? ?????? ??? ???? ??? ???? ??????:
   A1: 10   B1: 2    C1: 4
   A2: 14   B2: 18   C2: 9
   A3: 7    B3: 17   C3: 12
   A4: 1    B4: 13   C4: 5
   A5: 11   B5: 8    C5: 16
   A6: 3    B6: 6    C6: 15
				
????? ??????? ????? ??????? ?? ??? ?????? ??? ????? ????? ?? ????? ??????. ??? ??? ?????? ????? ???? ?? ???????? ????? ??????? ???????:
   A1: 1    B1: 7    C1: 13
   A2: 2    B2: 8    C2: 14
   A3: 3    B3: 9    C3: 15
   A4: 4    B4: 10   C4: 16
   A5: 5    B5: 11   C5: 17
   A6: 6    B6: 12   C6: 18
				
?????? ??????? ????? ???? ??? ?? ???? ???? ??????? ???????:
  1. ??? ???? ????.
  2. ???? ???????? ????????? ??????? ?? ???? ?????:
       A1: 10   B1: 2    C1: 4
       A2: 14   B2: 18   C2: 9
       A3: 7    B3: 17   C3: 12
       A4: 1    B4: 13   C4: 5
       A5: 11   B5: 8    C5: 16
       A6: 3    B6: 6    C6: 15
    					
  3. ?? ??????? ?????? ??? ??? ????? ? ?? ???? ??? ???? Visual Basic.
  4. ?? ??????? ????? ? ???? ??? ???? ?????.
  5. ???? ???????? ???????? ??????? ?? ?????? ???????:

    ?????? ???? ?????? ?????? ????? ??? ?? ????? ??????. ????? ????? ??? ?????? ????? ?????? "Order1: =" ????? xlDescending.
       Sub SortAllRangeData()
       ' Place column header for temporary sort area.
       Range("IV1").Value = "Numbers"
       
       ' Move numbers to temporary sort location.
       For Each cell In Selection
          Range("iv65536").End(xlUp).Offset(1, 0) = cell.Value
       Next cell
       
       ' Sort numbers in ascending order.
       Range("IV1", Range("IV1").End(xlDown)).Sort Key1:=Range("IV2"),  _
       Order1:=xlAscending, Header:=xlGuess, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
            
       ' Move sorted data back to original sheet location.
    
       Selection(1, 1).Activate ' Make sure the ActiveCell is the
                                ' top left of Selection first.
       CCnt = Selection.Columns.Count
       RCnt = Selection.Rows.Count
       CellCnt = Selection.Cells.Count
       Tcell = 2
       For c = 1 To CCnt
         For r = 1 To RCnt
            Range(ActiveCell.Address).Offset(r - 1, c - 1).Value =  _
            Range("iv" & Tcell).Value
            Tcell = Tcell + 1
         Next r
       Next c
       
       ' Clean up temporary sort location.
       Range("IV1", Range("IV1").End(xlDown)).Clear
    End Sub
    					
  6. ?? ????? Excel ?? Microsoft Excel X ?? Mac ??? ?????????? ??????? ?? Excel ????? ??????? Mac ?? ??????? "???" ?? ???? ??????? Excel ???? ??? ????? ????? ??? Microsoft Excel.
  7. ??? A1:C6.
  8. ?? ??????? ?????? ??? ??? ????? ? ?? ???? ??? ????? ???????. ??? ??????? SortAllRangeData ?? ???? ??? ?????.
???? ???????? ???????? ???? ?????? ?????? ???? ??? ?? ???? ??? ???:
   A1: 1    B1: 7    C1: 13
   A2: 2    B2: 8    C2: 14
   A3: 3    B3: 9    C3: 15
   A4: 4    B4: 10   C4: 16
   A5: 5    B5: 11   C5: 17
   A6: 6    B6: 12   C6: 18
				

?????

Excel X ?? Mac ?????????? ??????

?????? ??? ???? ?? ????????? ??? ????? ??? ? ???? ??? "??????? Excel" ?? ??????? ??????? ???? ??? ? ???? ??? ??? ?? ???? ??? ????? ?????.

?????? ??? ???? ?? ????????? ??? ????? ??????? ????? ??? ?? "???? Visual Basic ???? ???" ??????? Visual Basic "?? ??????? ??????? ? ???? ????? ????? ???? ??? ??? ?? ???? ??? ??? ??? ???????.

Excel 2001 ?? Mac

????? ?? ????????? ??? ????? ??? ???? ??? "????? Office" ? ???? ??? ????? ? ???? ??? ??? ?? ???? ??? ????? ?????.

?????? ??? ??? ??????? ?????? ???? ??? ?? "????? Office" ??? ???? ??????? ?????.

?????? ??? ???? ?? ????????? ??? ????? ??????? ????? ??? ?? "???? Visual Basic ???? ???" ????? Office "? ???? ????? ????? ???? ??? ??? ?? ???? ??? ??? ??? ???????.

???????

???? ???????: 247311 - ????? ??? ??????: 06/????/1428 - ??????: 6.3
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X ?? Mac
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt kbautomation kbprogramming kbhowto KB247311 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????247311

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

 

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