Try this array formula entered with CTRL + SHIFT + ENTER
=INDEX(A1:M1,MIN(IF(A2:M2<>0,COLUMN(A2:M2))))
A1:M1 are the dates A2:M2 are the Sales forcasts.
Try this array formula entered with CTRL + SHIFT + ENTER
=INDEX(A1:M1,MIN(IF(A2:M2<>0,COLUMN(A2:M2))))
A1:M1 are the dates A2:M2 are the Sales forcasts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks