PC Review


Reply
Thread Tools Rate Thread

comparing 2 fields/cells and displaying a message programitcally

 
 
=?Utf-8?B?cXVlc3Rpb24xMg==?=
Guest
Posts: n/a
 
      29th Jan 2007
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?VG9tIE9naWx2eQ==?=
Guest
Posts: n/a
 
      29th Jan 2007
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:45 PM.