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

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

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

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

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

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