Largest value in an Excel range - ignoring blank, text or error cells
This presentation will provide you one approach to find the largest value across blank, text or error cells in a financial model.
The video presents a sample of trade data with the following details, which contain some ad-hoc errors and omissions. The standard MAX function in Excel will be unable to work with a range, which contains non-numerical cell values such as errors, blanks or text.
We require an alternative function and formula, which will derive the largest value of 79,092. There are two approaches we will use to solve this.
Feel free to also check out an earlier video, "Sum an Excel range - ignoring blank, text or error cells" ( • Sum an Excel range - ignoring blank, ... ), as well as last week's video on solving an average value over blank, text or error cells ( • Average an Excel range - ignoring bla... ).
Смотрите видео Largest value in an Excel range - ignoring blank, text or error cells онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Strategize Financial Modelling 11 Февраль 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,503 раз и оно понравилось 6 людям.