Ian wrote in looking for an Array Formula that would build a unique list of managers who belong to a selected VP. Since Ian has Excel 2013, in Episode #1798 I propose using Slicers instead of the insanely difficult Array Formulas.
“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! 35% More Tips than the previous edition of Bill’s book!
And if you would like to learn more about Array Formulas…
Although elusive, Array Formulas can be used to solve everyday Excel problems. If you need to figure out how many times your birthday fell on a Friday, an Array Formula can solve that. If you need to return a Unique List of Sales Reps from a Database, an Array Formula can solve that. Now, at your own pace, you can learn the methods, the tricks, the dos and the don’ts that will allow you to “Command The Power of the ‘Array Formula’ in Microsoft Excel“! “Ctrl+Shift+Enter: Mastering Excel Array Formulas” by Mike ‘ExcelIsFun’ Girvin tells all!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and