unique records

  • Thread starter Thread starter Leslie Burns
  • Start date Start date
L

Leslie Burns

Can someone help me with finding unique company names in a spreadsheet. I
was given this formula, but it doesn't seem to work

I have the names in D2, so I used
=COUNTIF(D2:OFFSET(D2,,,COUNTD(D:D)-1),D2)=1

Below is the original response. Thanks.[/QUOTE]
1. In an open cell outside your data key in this (say E5):

2. Click somewhere inside your data.
3. Go to Data > Filter > Advanced Filter
4. XL should recognize the range and fill in the "List
Range" for you.
 
Leslie,

When you changed the references from column A to column D, you should not
have changed the COUNTA. So your formula should read
=COUNTIF(D2:OFFSET(D2,,,COUNTA(D:D)-1),D2)=1


This is a bit odd as well, how do you want to see the uniques. If you put
this, very similar function, in E2 and copy down all rows, it will name the
unique names
=IF(COUNTIF(D:D,D2)=1,"Unique","")

--

HTH

Bob Phillips

Leslie Burns said:
Can someone help me with finding unique company names in a spreadsheet. I
was given this formula, but it doesn't seem to work

I have the names in D2, so I used
=COUNTIF(D2:OFFSET(D2,,,COUNTD(D:D)-1),D2)=1

Below is the original response. Thanks.
1. In an open cell outside your data key in this (say E5):

2. Click somewhere inside your data.
3. Go to Data > Filter > Advanced Filter
4. XL should recognize the range and fill in the "List
Range" for you.
5. In critera range put:

making sure that E4 is empty.
6. Press OK.
[/QUOTE]
 
Back
Top