Forum Discussion
Rafael Donado
Sep 04, 2017Copper Contributor
Excel: Value "cero" vs Empty Cell
Hi every one (sorry for my english, not native). I'm working on a table in which i need to see the minimum value of a column. I have no problem when there are values in some of the cells, the progra...
- Sep 04, 2017
Rafael,
one way:
=IF(COUNT(A1:A10),MIN(A1:A10),"")
Detlef_Lewin
Sep 04, 2017Silver Contributor
Rafael,
one way:
=IF(COUNT(A1:A10),MIN(A1:A10),"")
- Rafael DonadoSep 05, 2017Copper Contributor
Thanks! this was exactly what i was looking, clever solution.