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

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

Alan Wrote:
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 -
Alan - your formula is missing something. Also where do I put the
checked value? Since the spreadsheet is in continum A1:j50, i would
like to get a checked result some where out of this range.




--
Ash

Sorry, should be
=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")
You can enter this formula anywhere you want to and change the A$1:A$50 to
the column you want to check,
Regards,
Alan.

"Ash" wrote in message
...

Alan Wrote:
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 -
Alan - your formula is missing something. Also where do I put the
checked value? Since the spreadsheet is in continum A1:j50, i would
like to get a checked result some where out of this range.




--
Ash

Alan Wrote:
Sorry, should be
=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")
You can enter this formula anywhere you want to and change the A$1:A$50
to
the column you want to check,
Regards,
Alan.

"Ash" wrote in message
...-

Alan Wrote:-
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 --
Alan - your formula is missing something. Also where do I put the
checked value? Since the spreadsheet is in continum A1:j50, i would
like to get a checked result some where out of this range.




--
Ash -
Alan - I know you are trying to help me and I really appreciate it. But
you gave me the same formula again. I am getting an error message every
way i tried. when I select the whole spreadsheet and put the formula
below data cells I get a circular ref error.
I can email you if you want. My email is




--
Ash

Ash and Alan,

This is what's happening. I don't know what caused it though.

Both times Alan wrote this formula

=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")

which includes the greater than sign "" i.e. 1.

However, when Ash replied, the message quoted dropped the greater than sign.

It read: Alan wrote .......

=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")

See how the message dropped the greater than sign from the formula?

Ash, make sure you have 1 in the formula. Try to type in the formula instead of copy/paste. If your last column is J, try to use column k or l or m for the formula.

You said you had 12 columns. So, I don't understand why you said earlier your last column would be J? A to J = 10 columns. I am lost.

Epinn

"Ash" wrote in message ...

Alan Wrote:
Sorry, should be
=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")
You can enter this formula anywhere you want to and change the A$1:A$50
to
the column you want to check,
Regards,
Alan.

"Ash" wrote in message
...-

Alan Wrote:-
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 --
Alan - your formula is missing something. Also where do I put the
checked value? Since the spreadsheet is in continum A1:j50, i would
like to get a checked result some where out of this range.




--
Ash -
Alan - I know you are trying to help me and I really appreciate it. But
you gave me the same formula again. I am getting an error message every
way i tried. when I select the whole spreadsheet and put the formula
below data cells I get a circular ref error.
I can email you if you want. My email is




--
Ash

Ash,

The formula is correct. You need to enter these formula at the next
column not at the same column. That's why you are getting the circular
references. Copy and and paste the formula to all the columns till you
need to now the duplicate entries.

Hope that helps,

Thankyou,

Shail


Ash wrote:
Alan Wrote:
Sorry, should be
=IF(COUNTIF(A$1:A$50,A1)1,"Duplicate","")
You can enter this formula anywhere you want to and change the A$1:A$50
to
the column you want to check,
Regards,
Alan.

"Ash" wrote in message
...-

Alan Wrote:-
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 --
Alan - your formula is missing something. Also where do I put the
checked value? Since the spreadsheet is in continum A1:j50, i would
like to get a checked result some where out of this range.




--
Ash -
Alan - I know you are trying to help me and I really appreciate it. But
you gave me the same formula again. I am getting an error message every
way i tried. when I select the whole spreadsheet and put the formula
below data cells I get a circular ref error.
I can email you if you want. My email is




--
Ash