Hey Guys,
I found myself a bit in a pickle… I need to do a simple TRUE/FALSE/NOT APPLICABLE check but based on a number of defined conditions.
The background to it is:
1) We are producing a set of components
2) Each of the components has a unique reference (Column A)
3) For each of the components there are either 1, 2 or 3 associated drawings (Column B)
4) Each of the drawings has a status (Column C)
5) I need to perform a check to see if all drawings associated to the component are at status “E – Exported”. Right now it is a manual and a very laborious process
6) The conditions are as follow:
a. If all of the drawings (B) associated to the component (A) have status “E – Exported”, than the check = TRUE
b. If some, but not all of the drawings (B) associated to the component (A) have status “E – Exported”, than the check = FALSE
c. If there are other statuses but no status “E – Exported”, than the check = N/A
I have attached an example of a number of possible conditions for which I need the formula to spit out N/A, TRUE or FALSE.
Hope all this blubber makes sense (I included some notes in the file).
To be perfectly honest, I don’t even know where to start! Your help would be greatly appreciated!
Thanks,
Krzys (bond002)
Bookmarks