Hi
When you want to find all occurrences of entries, starting from second (i.e.
you mark out 2nd, 3rd, etc. occurrence of incoice number in table), then
select the range A1:Gx (x is at least the number of rows in your table),
from Format menu select conditional formatting, like in Cezar's response set
'Formula is', and into formula field enter
=(COUNTIF($A$1:A1,A1)1)
After that set the cell format for case the formula returns TRUE, and click
on OK.
Arvi Laanemets
"Bennie" wrote in message
...
Hello! I have a very large spreadsheet and I need to search it for a
duplicate invoice numbers. I am entering invoice numbers in the first
seven
columns. Can you tell me the easiest way to check the first seven columns
for for duplicate numbers? Thanks for your help!!!
|