Find That Address without A GPS!
“And what does ‘Control + R’ do, exactly?” Find out!”
JP Pinto won the fan-favorite Great White Shark award for his previous post about Cascading Validation Lists. The folks at the Office Online blog asked JP to do a new guest post for the Excel blog and JP’s post on using INDEX and SUMPRODUCT to do a two-criteria lookup is now available here. This looks(…)
Extreme LOOKUP Podcast Duel
Use a Pivot Table to Count Between Ranges