ExcelisFun

Dueling Excel – “VLOOKUP EBay fee, but not over Max”:Podcast #1805

               

Today, Mike and Bill look at Ebay and VLOOKUP. Suppose we have a different Rate per Category, and Back

Dueling Excel – “Average by Category Excel 2003”: Podcast #1800

               

Today, in Duel 142, we start back in Excel 2003 to create an Average by each Category that will work Back

Dueling Excel – “Can You SUMPRODUCT 3 Lookups?”: Podcast #1795

               

Today, in Dueling Excel Episode #141, we note that this Duel started out as a simple request: Back

Dueling Excel – “Stock Symbol (Last 2 Words)”: Podcast #1789

               

It’s Friday and once again time for Dueling Excel, with Mike ‘ExcelIsFun’ Girvin and Bill ‘MrExcel’ Jelen. Today in Duel #140 we find that – in a Spreadsheet – one Cell has a Security Name, Ticker Symbol and Back

Dueling Excel – “Employees by Department”: Podcast #1788

               

Today, in Duel #139, Tom would like to do a VLOOKUP to pull all employees for a Back

Learn Excel from MrExcel