Thread: Dynamic Ranges Adding Extra Row
View Single Post
  #3   Report Post  
KeriM KeriM is offline
Member
  
Posts: 70
Default
Quote:
Originally Posted by Claus Busch View Post
try:
=OFFSET($A$1,1,,COUNTA($A:$A)-1)
Thank you! That solved it! :)
Reply With QuoteReply With Quote