Excel Min Formula-Ignore Zero for Non-Contigous Range.wmv

preview_player
Показать описание
This tutorial will help you to find the min value and ignore Zero from the non-contiguous range.
Shine in Excel and VBA. For more interesting tips and tricks visit my website.
Рекомендации по теме
Комментарии
Автор

Subscribed! thank you so very much ... this is THE ONLY video i could find on the ENTIRE WEB explaining how to calculate min value, whilst ignoring zero value ... FROM A NON-CONTIGUOUS RANGE!!! No one else seems to think it was important!! THANK YOU SO VERY MUCH!!

leoncoetzee
Автор

Thank you very much.  This was very helpful and allowed me to get what I needed quickly.

ttzJason
Автор

Thanks for this! How do you do it when you're looking for min from more than a hundred cells?

joselicop