Not enough detail to answer. Basically, you do it the same in Excel 2008 as you do on the PC. Search for 'duplicate' in the Excel Help and it shows two techniques. Give me more detail on what you need and we can be more help.
Oct 10, 2018 The contents in both columns are only numbers. For example: if A1 match B64 - highlight them both in yellow; if A12 match B2 - highlight them both in yellow. This thread is locked.
On 6/06/10 12:45 PM, in article [email protected], ' wrote: - The email below is my business email - Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia.
Ph: +61 (0)4 1209 1410 mailto: [email protected] 6/6/2010, 10:48 น. Let me try this again I use excel to manage pipe ID numbers.
These numbers are received from 6 separate pipe yards. I have all ID numbers in a column where I want to identify if I have entered a duplicate value/ID number by using conditional formatting highlighted cell rule, duplicate values. In Excel 2008 under conditional formatting there is no selection for Highlighted Cell Rules, Duplicate Values.
There is equal to, greater than, less than etc. I would like to know if there is a way to identify (highlighted cell) if I enter a duplicate value by having Excel identify this and warn me I already have this value in this column. On my PC I have Excel 2007 which has the option to select duplicate values. If this is possible in Excel 2008 please advise how to do it because I can not find it. Thank You for your reply Not enough detail to answer. Basically, you do it the same in Excel 2008 as you do on the PC. Search for 'duplicate' in the Excel Help and it shows two techniques.
Give me more detail on what you need and we can be more help. On 6/06/10 12:45 PM, in article [email protected].
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |