Hello. I have an if/and formula that is working just fine however, I'm wondering if when there is no data returned (either N/A or "blank") can that cell not show up?
Example: Now
A1: NA
A2: NA
A3: Hobbit
A4: Harry
A5: N/A
A6: Speed Racer
Example: What I'm trying to get
A1: Hobbit
A2: Harry...