I need Help on Excel

Intel / 00000000000000000000000
January 9, 2009 at 01:38:31
Specs: Windows XP, 1200
Excel Formula help

I am trying to create a spread sheet for Employees ID with their names.

1) I am creating "sheet1" for New Employees and have to allot them New Employees ID's but while alloting ID's I have to check "Sheet3" and confirm the ID which I am alloting is not Present then only I can allot it. If it is already present in "sheet3"; I have to recheck for next number i.e. +1 and have to see if it is not present then I can allot it in "Sheet1".

Example: IF "3001" is present in Sheet3 I have to check +1 number i.e. "3002" if it is not present I have to allot for New employee in "Sheet1"

how Can i do it with Excel Formula.

Thanks in advance

See More: I need Help on Excel

Report •

January 9, 2009 at 05:01:35
It's possible, but I'd recommend using a simple Access database and make the employee id the Primary Key. Then, you won't have any duplicates.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown

Report •
Related Solutions

Ask Question