Good day MarvinP, thank you for giving me some materials to teach myself about pivot table. Apparently i need to search some other learning materials about pivot tables for beginners like me because upon checking the files, it might take me time to understand. On the other hand, i was able to simplify my requirements and i think it will only need a formula.

Using the same worksheet - the formula should be on Column E and will 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. Then the adjacent cell or D28 should not be equal to blank. Result: The cell E28 should return Available.

I know the formula how to get Deployed.

on Cell E2
Formula: copy to clipboard 
=IF(D2="","Deployed","")


I just need to have that formula modified to get the Available.