Excel: Determine if equipment Available or Deployed

https://docs.google.com/spreadsheet/ccc?key=0AlkV6TxHhBO3dEhJb1pIeks0N2drOE40OU5nNmhPeXc&usp=drive_web#gid=0 The table is a tracking for equipment rental. Each Door No. has a history, for example the Door No. ATC0005 took up the Cell A2 to A8. Each history has a record of Date Mobilized and Date Demobilized. I need a formula to under Column E to return only 2 values: Deployed or Available. A. Deployed is returned by determing if a certain cell under Date Demobilized is blank. B. Available is return by determining 2 conditions using AND statement. 1. Get the list of Door No. that has the same value, for example ATC0010 (Row 25 - 28), it needs to determine the cell which has the recent date of Date Mobilized, in that case its C28. 2. The adjacent cell or D28 should not be equal to blank. Result: The cell E28 should return available

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of December 03, 2013.

For more resources for Microsoft Excel