View Single Post
Old 05-25-2023, 06:28 AM
RaeCalcipher RaeCalcipher is offline Windows 11 Office 2021
Join Date: May 2023
Posts: 2
RaeCalcipher is on a distinguished road
Default 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!
Attached Images
File Type: png excel example.PNG (12.2 KB, 12 views)
Reply With Quote