Forum Discussion
"Smart" Excel Formulas - Autofill based on number of rows in another sheet
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 "".
creidy Now, I'm not offering you the "smart" solution as I believe your situation can be quite easily handled by IFFEROR and IF, copied down to a range you feel comfortable with. A hundred or a thousand rows, that doesn't really matter. A smarter solution would entail formulae that would be neither straight-forward nor easy to maintain, whereas the attached (revised) workbook contains formulae that are. See for yourself and decide if you can live with it.
Alternatively, consider Power Query to connect to the "Report" and have it transform in the matter of seconds, no matter how short or long the Report is. Set it up once and you can refresh the query at any time.
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!