Good afternoon, evening or night,
I have been working on modifying a sheet which has been in use for some time. It is a manually input sheet which has data for a bunch of different machines which are given number designations(1, 2, 3, 4, etc). Each of these units has equipment which is numbered as well and interchangeable(Machine 1 and 2 can use Equipment 1 or 2 or 3 for example). I keep track of the amount of times these are on the sheet each month.
I previously discovered after much toil that the person entering the data was sometimes entering it incorrectly. I have written some functions using countifs to get the number of times a certain machine number count is equal to the number of times when a machine number corresponds to a given equipment number. If the data is entered correctly on the sheet, the answer should be 0. However if the data has an error in it it will return a number. I then have a function that breaks down with a Countifs where the criteria is data that is not any of the equipment that should correspond to the machines capable equipment. This number should always be 0 if correct, however I would like to write a function that will give me the address of the result of this countifs formula. Is there any way to find a cell address where criteria is not met?
Thank you in advance!
I have been working on modifying a sheet which has been in use for some time. It is a manually input sheet which has data for a bunch of different machines which are given number designations(1, 2, 3, 4, etc). Each of these units has equipment which is numbered as well and interchangeable(Machine 1 and 2 can use Equipment 1 or 2 or 3 for example). I keep track of the amount of times these are on the sheet each month.
I previously discovered after much toil that the person entering the data was sometimes entering it incorrectly. I have written some functions using countifs to get the number of times a certain machine number count is equal to the number of times when a machine number corresponds to a given equipment number. If the data is entered correctly on the sheet, the answer should be 0. However if the data has an error in it it will return a number. I then have a function that breaks down with a Countifs where the criteria is data that is not any of the equipment that should correspond to the machines capable equipment. This number should always be 0 if correct, however I would like to write a function that will give me the address of the result of this countifs formula. Is there any way to find a cell address where criteria is not met?
Thank you in advance!
