Assuming the values you need to check are in A1:A50, enter into B1 and copy
down to B50,
=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")
Then if you wish, sort columns A and B by column B. You could also look at
Conditional Formatting in Help to colour the duplicates red or whatever.
Obviously change the cell references to suit your needs,
Regards,
Alan.
"Ash" wrote in message
...

I have a spreadhseet that has 50 rows (steps) and 12 columns. The
columns represent groupings while the row are an assigned steps in the
pay schedule. The first column A (monthly pay) is column B (annual
salary) divided by 12. The same is true for the rest of the columns
like C and D, E and F, G and H and I and J. Recently I was given a task
to raise salaries by a same factor for all employees. I did this using
simple formulas and checked the result the long way by printing and
going through the whole record. My question is does any one know a
formula to check for duplicate figures? obviously the same rate can not
be applied to two employees at different Steps and Columns.




--
Ash