Episode 143

Sometimes you need a formula to always point to a particular row but allow the column to change. Or, you might need it to point to a particular column but allow the row to change. This is called Mixed References. Episode 143 will show you both varieties.

This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!