Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() rearrange cells based on its numerical values without repeating -------------------------------------------------------------------------------- with this sub 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 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 ?? -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=487041 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
can excel draw a shape based on values entered in cells | Excel Worksheet Functions | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |