We celebrate 13 years of podcasting (on the 13th), I tell the story of how my doorbell informed us that our UPS had died. We hear the interview with Boinx from NAB, and I’ll explain how Rogue Amoeba’s Audio Hijack solved two problems on an airplane. I get my Excel geek on when I solve […]
Continue readingTag: mrexcel
How to Find the Cell Reference for a Searched Value in an Array in Excel
John Ormsby (aka NASANUT) sent in what he playfully called a Dumb Question: I have a spreadsheet that contains a 10 by 10 matrix of values. Each value is different. There are column headings at the top, ranging from 0 to 9 and there are row headings on the left, also ranging from 0 to […]
Continue reading