Jump to content
LCVG

Excel Question


Starhawk
 Share

Recommended Posts

I don't think there is an easy way to do that. My best suggestion - other than using Microsoft Access ;) - would be to sort them and then use a formula (that would have to be pasted in ever single row) to determine if there are duplicates, or to use some VBA to check it for you. If you go the formula route I've got an idea for how it should be structured that I think would work.

 

[EDIT]

This formula would work (if your list is sorted), and changing the cell references of course:

=IF(A1=A2,TRUE,IF(A2=A3,TRUE,""))

 

If there's any duplicates, it will say "TRUE" next to the repeats, otherwise, it'll be blank.

[/EDIT]

Link to comment
Share on other sites

A quicker way would be to use the following formula:

 

=COUNTIF(A:A,A1)

 

This assumes that the values you are checking for duplicates reside in column A and that your first value is in cell A1.

 

Change references as applicable to fit your sheet and copy all the way down the column to match your list.

 

This method does not require you to sort the list first.

Link to comment
Share on other sites

Originally posted by blackcalx@Jun 1 2004, 04:51 PM

A quicker way would be to use the following formula:

 

=COUNTIF(A:A,A1)

 

This assumes that the values you are checking for duplicates reside in column A and that your first value is in cell A1.

 

Change references as applicable to fit your sheet and copy all the way down the column to match your list.

 

This method does not require you to sort the list first.

Cool - I wasn't the one asking the question ;) but I'll have to remember that one :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...