First off, so very happy to have found this Forum!! Being able to tap into so much expertise is invaluable to me!
Second, I feel so incredibly stupid -I know what I'm asking is fairly straightforward but I just can't figure it out.
I have a very simple spreadsheet I maintain which lists active employees of a certain type. Another department in my company would like to receive a copy each month so they have an updated list.
My spreadsheet has several columns that the other department doesn't need. I created another sheet in the same workbook and used a simple array formula to display columns A-P of the source sheet. I adjusted the formatting so it essentially looks just like the other, but without the unnecessary columns. My hope is to just periodically save this other sheet to a new workbook and email it once per month to the other department.
The issue I can't resolve is this: my array formula sheet returns zeroes for any blanks in the source sheet. Is there a way to have it return blanks instead?
Thanks in advance for your help!!
Bookmarks