Forum Discussion
Solved
"Smart" Excel Formulas - Autofill based on number of rows in another sheet
Hello, I have created a workbook with two sheets - the first ("Report") where an Excel report is downloaded from a software and pasted into the sheet and the second ("Calculations") where a serie...
creidy I use MailMerge once per year, so I'm not an expert here, but believe you can filter out records that meet a certain criteria. So, just don't include records that have "".
Riny_van_Eekelen I haven't even thought about a Power Query in a decade and would have to relearn it all again, but that is a fantastic suggestion!
Your "IF" formula solution was prefect for not viewing the information. What I failed to include in my original post (updating now) is that the data in "Calculations" will be used for a mail merge. Unfortunately, mail merge fully recognizes those cells as containing data and tries to tell me that there are 100 recipients listed. This might be the same issue with a Power Query, now that I think about it...
Your "IF" formula solution was prefect for not viewing the information. What I failed to include in my original post (updating now) is that the data in "Calculations" will be used for a mail merge. Unfortunately, mail merge fully recognizes those cells as containing data and tries to tell me that there are 100 recipients listed. This might be the same issue with a Power Query, now that I think about it...
creidy I use MailMerge once per year, so I'm not an expert here, but believe you can filter out records that meet a certain criteria. So, just don't include records that have "".
Riny_van_Eekelen - You are Godsent. Seriously. The issue was that the blank time column still had a "date/time" in them. After I read this, I changed the filter to ignore anything without a first name, regardless of the other cell's content, and voilà! I honestly cannot thank you enough!
creidy Most welcome!