You can try:
confirmed with CTRL+SHIFT+ENTER not just ENTER![]()
=MIN(IF(ISNUMBER(A1:E1),IF((MOD(COLUMN(A1:E1)-COLUMN(A1),2)=0)*(A1:E1),A1:E1)))
Gives you 0 if you have all blanks.
You can try:
confirmed with CTRL+SHIFT+ENTER not just ENTER![]()
=MIN(IF(ISNUMBER(A1:E1),IF((MOD(COLUMN(A1:E1)-COLUMN(A1),2)=0)*(A1:E1),A1:E1)))
Gives you 0 if you have all blanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks