excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Andrea has attended:
Excel Intermediate course

Excel

How to find duplicates in Excel spread sheet database?

Edited on Thu 8 May 2008, 15:53

RE: Excel

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 & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Server loaded in 0.07 secs.