Put this formula in cell E2 and copy it down the column: =IF(AND(D2="",C2<>""),C2,IF(AND(D2<>"",C2=""),D2,"NA"))
Put this formula in cell E2 and copy it down the column: =IF(AND(D2="",C2<>""),C2,IF(AND(D2<>"",C2=""),D2,"NA"))
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks