My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Posts Tagged → volatile

Dynamic Ranges Using Index Function

posted in Efficiency on January 22, 2019 by Kevin Lehrbass 6 Comments

Robert H. Gascon’s comment from my last post convinced me that I should be using the INDEX function for dynamic ranges not the volatile OFFSET function. Continue reading →

Sometimes I write a practical 'how to' post and other times I explore a crazy idea and build something unique. I love working with data in Microsoft Excel!

Kevin Lehrbass

Newsletter