Highlight duplicate values
In Excel, Office 2007, I have the option to highlight duplicate values on the menu. Keep simple! Select the column, select "Conditional Formatting" - "Highlight Cells Rules" - "Duplicate Values" and voilá! All values that were duplicate on this column it was paint with color red, for example.
Actually I use the LibreOffice Calc, version 220.127.116.11, and I can't find this option on the menu!
How can I do this job?
Select the column of numbers and note the 'active cell' (A1 in the sample image below). Go to Format ► Conditional Formatting and set up a rule as a formula using
It is important to get the 'active cell' correct. If the 'active cell' was A15 then that formula would be
I've also put the formula in column C so that you can see how each row resolved to TRUE or FALSE.