MailMerge Formula
So I have a conundrum, and a lot of questions. I am trying to merge an excel sheet into mail merge. Simple, understand the process straight up, but for this task I need to get a lot of complicated. But first, this is the excel sheet I'm looking at is attached.
What I want to do is basically:
IF the street name column has a value use the new value. IF the street name value is blank THEN use the last value notated. Continue until a new value is seen, and repeat.
But every type of formula I've thought of and tried, it has not been successful. Can I create that formula, if so where do I start. OR do I have to be rudimentary and just fill in the blanks. It's totally okay if that's the answer and I'm just trying to be far more clever than possible.
Thank you!
|