comparing 2 fields/cells and displaying a message programitcally

's Computer Specifications

Hi, I have an excel file that reads in data from a text file. After the data
is read in, I want to check a column of data (job #'s) to see if any repeat.
If it does repeat, I want to display a message to the user which rows repeat.

Can this be done in excel? Thank you for your help

's Computer Specifications

Look at Chip Pearson's page on duplicates

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"question12" wrote:

> Hi, I have an excel file that reads in data from a text file. After the data
> is read in, I want to check a column of data (job #'s) to see if any repeat.
> If it does repeat, I want to display a message to the user which rows repeat.
>
> Can this be done in excel? Thank you for your help

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing memo fields, and displaying differences	Dale Fye	Microsoft Access	5	18th Sep 2009 07:26 PM
Comparing memo fields, and displaying differences	Dale Fye	Microsoft Access VBA Modules	5	18th Sep 2009 07:26 PM
Comparing Cells and Displaying Data	=?Utf-8?B?S2VpdGggQnJvd24=?=	Microsoft Excel Worksheet Functions	1	9th Feb 2005 05:42 PM
Comparing two fields and displaying difference if text is present.	Alex	Microsoft Excel Misc	2	17th Mar 2004 10:17 PM
Comparing two fields and output message	Javes	Microsoft Access Form Coding	1	4th Feb 2004 12:06 AM