Forum Discussion
Non-Consecutive Cell Referencing
Thank you also for your help. I will stick to your proposal for the reasons you give. But I will play around with all suggestions just to get an idea of how and why these functions work. Have a Merry Xmas!
Nobody has yet asked a question that I wanted to ask from the start: Why?
You don't have to answer, of course; may even view it as an impertinent question: what business is it of mine to question your question?!
But I am curious. It's an unusual request, and seems like a strange task. In general I'm a person who likes to keep rows and columns filled, not have blank rows or columns between sets of data, yet here you're going to lengths to create blank rows! So you've piqued my curiosity.
Are you willing to share the purpose? How you'll be filling or using those newly created blank rows?
as always, you have good questions and if they told us why the gaps or what will go in the gaps we might create a single array function to fill the whole column. But I'm assuming the intend to fill those gaps with something and hence why I specifically didn't use an array function to fill the whole column