SHARE
TWEET

Untitled

a guest Jun 25th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =IF(A1<>"Vacant",IF(B1="x",A1,""),"")
  2.      
  3. =IF(A2<>"Vacant",IF(B2="x",A2,""),"")
  4.      
  5. =IF($A$1<>"Vacant",IF(B1="x",A1,""),"")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top