| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count and arrange cells have numeric values
heloo suppose i have 2 coloumns like this 2 microsoft 5 intel 3 ge 1 gm 2 microsoft 5 intel 7 tnt 12 att 24 blue 15 ntn how can i order them AScending in another column -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=486875 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count and arrange cells have numeric values
copy them to another range, then sort the copy of the data on the column you
wish. If you need code, turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy "amrezzat" wrote in message ... heloo suppose i have 2 coloumns like this 2 microsoft 5 intel 3 ge 1 gm 2 microsoft 5 intel 7 tnt 12 att 24 blue 15 ntn how can i order them AScending in another column -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=486875 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count and arrange cells have numeric values
i want it automatically not manually by functions or macros -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=486875 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count and arrange cells have numeric values
Sub doit()
Range("M1").currentRegion.ClearContents Range("A1").Resize(10,2).Copy Destination:=Range("M1") Range("M1").currentRegion.Sort Key1:=Range("M1"), Order1:=xlAscending End Sub -- Regards, Tom Ogilvy "amrezzat" wrote in message ... i want it automatically not manually by functions or macros -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=486875 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count and arrange cells have numeric values
thanks it works but i dont want to repeat the numbers i mean if i input 1 microsoft 2 intel 1 microsoft the results will be 1 1 2 i dont want that i want only 1 2 no repeating how can i do that -- amrezza ----------------------------------------------------------------------- amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876 View this thread: http://www.excelforum.com/showthread.php?threadid=48687 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count and arrange cells have numeric values
rearrange cells based on its numerical values without repeating -------------------------------------------------------------------------------- thanks it works but i dont want to repeat the numbers i mean if i input 1 microsoft 2 intel 1 microsoft the results will be 1 1 2 i dont want that i want only 1 2 no repeating how can i do that? noting that the input my be so long may be 1000 rows but they are only 50 companies (from 1 to 50) so the results will be in a max 50 rows and i want that code to activate(rerun) each time i enter the sheet2 how can i do that ? -- amrezza ----------------------------------------------------------------------- amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876 View this thread: http://www.excelforum.com/showthread.php?threadid=48687 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Count & Sum Consecutive (2x) appearance of Specific Numeric Values | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| count and arrange cell numeric values | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
![amrezzat[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
