unique records

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.
 
B

Bob Phillips

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top