to find and colour if it is a duplicate...

  • Thread starter Thread starter v9829
  • Start date Start date
V

v9829

I have a very large spreadsheet that I need to compare with another and find
the duplicates between both and delete them.
I would prefer to have the duplicates first highlighted [shaded or coloured]
so I can review them before deletion...
what formula would I use to do this? I'm rather new the excel and know a
little bit more then the basics.
Any help would be appreciated!
 
v9829 said:
I have a very large spreadsheet that I need to compare with another and
find
the duplicates between both and delete them.
I would prefer to have the duplicates first highlighted [shaded or
coloured]
so I can review them before deletion...
what formula would I use to do this? I'm rather new the excel and know a
little bit more then the basics.
Any help would be appreciated!
Click to expand...

Is this a question about using the Excel spreadsheet product, or a question
about programmatically accessing Excel spreadsheet data from a .NET
application?

If the former, you need to find a discussion group for Excel. Here's how...
As you appear to be using a web interface, start here to find an appropriate
group:

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

Click the + beside your language. then scroll down to Office and Desktop
Applications. In Office and Desktop Applications, open the category for
Excel, then find a group there to post in.

If the latter...
As you appear to be using a web interface, start here to find an appropriate
group:

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

Click the + beside your language. then scroll down to Developer Discussions.
In Developer Discussions, open the category for Visual Tools and Languages,
then find your language.
Word, then find a group there to post in.
 
Back
Top