Hi All
I am trying to create a document where there are different operations (processes within the factory) which are the headers for my columns. i am going to input a job number into the first column as it is the first operation, i would like to have a formula where when i then go on and enter the same job number into say column B or C depending on the next operation it automatically deletes the duplicated values wherever it may be. is this possible.
as there will be several hundred in the spreadsheet at a time my thinking is as the operator puts the job number into the next operations status column then it will auto delete from being in any other cell in the spreadsheet as one job can only be in one spot at a time.
I am trying to create a document where there are different operations (processes within the factory) which are the headers for my columns. i am going to input a job number into the first column as it is the first operation, i would like to have a formula where when i then go on and enter the same job number into say column B or C depending on the next operation it automatically deletes the duplicated values wherever it may be. is this possible.
as there will be several hundred in the spreadsheet at a time my thinking is as the operator puts the job number into the next operations status column then it will auto delete from being in any other cell in the spreadsheet as one job can only be in one spot at a time.