Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record

[krn14242]

Thanks Mike, I just love this formula and find myself coming back to it more and more.

[ExcelIsFun]

If you like this sort of formula, try this playlist:

Excel Extract Records From Database Table / List

There are least 10 similar formulas. The videos with the title 'Extract records... w Formula' are the ones that are similar!

But I think that you have already seen many of these!

By The Way, if you like this sort of formula, that makes you an Excel Master!

[everett99]

The dueling Excel is a barnstorm, it's great, but it doubles the time required for me to watch an Excel solution. And, for me, your style is very enthusiastic and entertaining. Which version of "It's a Wonderful Life" is better, black and white or color? Hands down a classic in either format, but black and white just delivers it better for me, so I'm glad to see just your videos, and cut my viewing time in half. Much respect to Bill, of course. GO SEAHAWKS!! Your bro, Ev.

[ExcelIsFun]

Got it!

I am glad that the videos help, and of course, thanks for watching!

[everett99]

Outstanding! Glad to see you back going solo.

[ExcelIsFun]

I am glad you like it!

What do you mean "solo"?