TRIMRANGE & A4.:.A8 in Excel to exclude future rows 

Thanks for this. I kinda understand this TRIMRANGE better. I thought it was related to TRIM, a function that I've never found useful. But TRIMRANGE might come in handy.

Would trimrange work with if is error