Largest value in Excel range (advanced approach) - ignore blanks, texts or errors
The source workbook is located here https://spreadsheetvault.com/largest-...
This video will present a solution for returning the largest value across a data range, which contains text, errors and blanks. In normal circumstances we could use the LARGE Excel function across a data range.
However, as we can see the LARGE function returns the #NAME? error value because this range contains cells with text or error values.
Fortunately, there is an alternative native Excel function, which can overcome the shortfall with the LARGE function.
Watch video Largest value in Excel range (advanced approach) - ignore blanks, texts or errors online without registration, duration hours minute second in high quality. This video was added by user Strategize Financial Modelling 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 333 once and liked it 6 people.