I have the below formula to remove blanks in a list and would like to add a separate cell value at the end of it (let's call it A1), not related to range V9:V22, but I would like A1 to show up below the list this formula creates:


Any quick add on to connect A1 to the end of this?


  • Do you know how to add a value to a simuliar formula? I'm using Google Sheets and Filter works.
    – Capt. Drew
    Feb 2 '18 at 19:08
  • Not using Excel, formula works fine....just need to put A1 at the end as a label.
    – Capt. Drew
    Feb 2 '18 at 19:13

That was an obvious fix, I just extended the range and made the last value in the filter what I needed.I put A1 at the end of range V9:V22.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy