comparing 2 fields/cells and displaying a message programitcally
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 |
comparing 2 fields/cells and displaying a message programitcally
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 |
All times are GMT +1. The time now is 02:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com