Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check for duplicate numbers
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
how can I check a worksheet for duplicate entries or numbers? | Excel Worksheet Functions | |||
check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
check numbers in a list | Excel Discussion (Misc queries) |