Posts tagged ‘Offset’
Learn Excel 2010 – “Get Next Record with Offset – Part III 0f IV”: Podcast #1548
Printing Database Records Individually – Part III of IV
Learn Excel 2010 “Dynamic Pictures”: Podcast #1417
Change a Picture based on a Cell…
Dueling Excel – Dynamic OFFSET or INDEX?: Podcast #1384
Dueling Excel – Episode #75 with Mike and Bill!
Lookup 2 Columns: Part II – Episode #1204
Solving the same problem from Episode 1203, doing a VLOOKUP that matches two columns, but without using a concatenated key. This solution uses the OFFSET function to dynamically change the position of the lookup table.
…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Concatenated Lookup? 1171a – Learn Excel from MrExcel
Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Episode 1171 Episode 1171 shows you how.
…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Concatenated Lookup? 1171 – Learn Excel from MrExcel
Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Episode 1170 Episode 1170 shows you how.
…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Duel: Portugal – 1139 – Learn Excel from MrExcel Podcast
A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Duel: Index:Index – 1134 – Learn Excel from MrExcel Podcast
Today’s Dueling Excel Podcast is a question sent in by Hassan. Hassan wants to enter a name and a through-month and then add up that person’s sales from January through the selected month. Mike and Bill show various methods in Episode 1134.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Offset Minus One – 1061 – Learn Excel from MrExcel Podcast
Julian wants to point to the row above the current row. This formula works fine until he deletes a row then those formulas change to #REF! errors. Julian asks how to point to “the row above” without specifying a row number. Episode 1061 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
