Re: How do I consoldiate a List of numbers to show each number onc

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Wiley.

Many ways to disrobe the feline.


Gord

On Fri, 14 Jul 2006 05:58:02 -0700, Wiley <Wiley@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Gord,

I agree. I like your solution better. I forgot about that feature.


"Gord Dibben" wrote:

The real easiest way is to use Data>Filter>Advanced Filter.

Check Unique records only and Copy to another location.

Needs no sorting, helper column, formula copying or deletion of columns.


Gord Dibben MS Excel MVP

On Thu, 13 Jul 2006 12:52:02 -0700, Wiley <Wiley@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

The easiest way is to highlight all the data columns, Sort by your number
list, and delete the duplicates. Or Autofilter for each value, right click
and delete the duplicates. If this is too large of a list to do manually,
you can create a fiormula in a new column:
1. After sorting, in the 2nd row that contains data in the new column,
create the follwoing formula:
=IF(A2=A3,"Y","N")
2. You iwll have to change "A" to the column letter containing your list.
The numbers in this formula assumes that Row1 is the header, and Row 2 starts
the data. Once entered, drag down to fill the formula in on the remaining
rows.
3. Autofilter the sheet by the "new column" you created for "Y".
Highlight all the "Y" rows, right click and delete.
4. Remove the filter and delete the formula column.

HTH


"PPete" wrote:

I have a list of numbers in a column that can repeat. I want to delete all
rows if that number is repeated.



.

Relevant Pages

  • RE: Unique Records in table
    ... This feature shows unique records based on all the fields, ... > After adding the fields in the Query Designer, select the No Duplicates ... > Purchase VFP8 here: ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Checking for Dups
    ... duplicates prior to saving a new record. ... check box on form to activate this feature. ... Show a listbox with companies sorted by phone number, highlighting the current data, and another listbox sorted by address, and one by name, etc. Let the user decide if any look like duplicates. ...
    (microsoft.public.access.formscoding)
  • Spam Control and Outlook
    ... I've had great success in automatically sorting loads of spam messages daily ... This puts junk mail in the Junk ... this function is not exactly the same in Outlook Web Access ... 2003 feature in OWA and Mobile? ...
    (microsoft.public.outlook.general)
  • Re: Extracting Duplicates from SQL Server 2000
    ... I have question regarding extracting duplicates from the dataset. ... Each records duplicating 1 times, thus, 10 unique records and 10 ... Here is the query that I used. ... select field1, field2, count ...
    (comp.databases.ms-sqlserver)
  • Problems with sharing a workbook
    ... We've got a weekly accuracy check spreadsheet that's on another drive and accessible to me and another co-worker. ... The data was first filtered to hide duplicates, then sorted by Employee ID and Date. ... I then went to Tools>Share Workbook, checked the box for sharing, and saved the workbook to our "G" drive. ... What caused that and what procedure should be followed to make sure that the initial filtering and sorting stays that way? ...
    (microsoft.public.excel)