Microsoft Excel has lots of engineering-related applications, and here's yet another: Creating traceability matrices to stay on top of Contract End Items (CEIs) for large projects. In large ...

Figure A We’ll create two Excel drop down lists based on this simple data set. We need two Excel drop down lists. The first Excel drop down list will set the condition, the region.