last cell
 

OK here it goes. I have a number of checkboxes which indicate areas where
work is to be done. i.e. Living room, Dining room, Hallway and so on. Column
V indicates which rooms have been checked. I need to formulate a sentence
which will include the word "and" before the last checked room. I have a
formula that does this now, however it will add the "and" even if only one
room is checked. I.e.
"Sand and refinish and Living room". Is there a way to fix this problem?
Thanks