Conditional Formating

Resolved · High Priority · Version 2007

Fri 12 Mar 2010, 12:19 Delegate Lorna said...

Lorna has attended:
Excel Intermediate course
Excel Advanced course

Conditional Formating

Hi,

I have a spreadsheet relating to students behaviour for the whole school. I would like to show duplicate incidents as staff think they have doubled up and want to delete the duplicates.

I have tried Conditional Formating - Highlight duplicates, but this isn't very helpful, it either highlights the whole sheet, or nothing at all.

the columns are: student name, registration group, incident type, date, staff member involved.

does anyone have any ideas of what is the best way to show duplicates.

thanks

Mon 15 Mar 2010, 10:43 Trainer Simon said...

RE: Conditional Formating

Hi Lorna,

Thank you for your question.

Have you tried the Remove Duplicates option in Excel 2007?

If not go to the Data tab, Data Tools group and select the Remove Duplicates option. Tick the boxes that may contain duplication, click OK and this will automatically delete any duplicates.

I hope this helps.

Regards

Simon

Sun 21 Mar 2010: Automatically marked as resolved.

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips

Conditional Formating

Conditional Formating

RE: Conditional Formating

Excel articles

Excel tip:

Using basic functions without doing formulas