Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Resolved · Low Priority · Version 2003
Andrea has attended:
Excel Intermediate course
How to find duplicates in Excel spread sheet database?
Hi Andrea, Welcome to the forum, Thank you for your post, sorry its taken a while to get round to answering it;
I suggest using conditional formats and the COUNTIF formula. So follow these steps: You will want to set up conditional formatting for the whole range, but it is easier to set up a conditional format for the first cell in the range and then copy that conditional format. In this case, let
|
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |
We'll call during UK business hours
Server loaded in 0.07 secs.