My Spreadsheet Lab

The site is about Microsoft Excel.

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

Posts Tagged → Leila Gharani

Video 00165 Show Column Header for Matrix Value

posted in Gurus on August 23, 2017 by Kevin Lehrbass 8 Comments

Last week I saw an interesting Excel puzzle from Leila Gharani on YouTube. Leila solved it using a sumproduct function. I made a video showing different solutions. Wasif Mustafa sent me his 3 helper column solution. Then Oz du Soleil created a video showing two solutions. So many ways to solve it! 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