| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
retrieve numbers excluding the repeticions
I Have one columm with numbers (with one or several occurrences) 34567 34567 54311 12345 54311 33321 ... and i want in other columm (only one occurrence of each number, preferably without blank spaces) 34567 54311 12345 33321 .... How can this be done??? Thanks :) -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=467841 |
|
#2
|
|||
|
|||
|
pmarques Wrote: I Have one columm with numbers (with one or several occurrences) 34567 34567 54311 12345 54311 33321 ... and i want in other columm (only one occurrence of each number, preferably without blank spaces) 34567 54311 12345 33321 .... How can this be done??? Thanks :) Use "Advanced Filter". Make sure your data range has a column header (e.g. "List"). Highlight the range of data (including the header) and choose: DataFilterAdvanced Filter... Select Copy to another location, enter the destination you would like to display the results in the Copy to: range, check the "Unique records only" box and click OK HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=467841 |
|
#3
|
|||
|
|||
|
One way is to use the unique filter in Advanced Filter
Assume data is in col A Insert a new header cell A1 (type a label), then select the column Click Data Filter Advanced Filter Check the boxes for "Copy to another location" & "Unique records only" In the "Copy to:" box, enter, say: B1 Click OK The list of uniques will be extracted in col B -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "pmarques" wrote in message ... I Have one columm with numbers (with one or several occurrences) 34567 34567 54311 12345 54311 33321 .. and i want in other columm (only one occurrence of each number, preferably without blank spaces) 34567 54311 12345 33321 ... How can this be done??? Thanks :) -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=467841 |
|
#4
|
|||
|
|||
|
:) It works fine Thanks a lot -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=467841 |
|
#5
|
|||
|
|||
|
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Linear Mode
