B7
=IF(COLUMN()=MIN(IF(ISNUMBER($B2:$I2),COLUMN($B2:$I12))),"x","")
Commit with Ctrl+Shift+Enter, drag down this formula to fit your range
Sample file is as attached
HTH,
windknife
B7
=IF(COLUMN()=MIN(IF(ISNUMBER($B2:$I2),COLUMN($B2:$I12))),"x","")
Commit with Ctrl+Shift+Enter, drag down this formula to fit your range
Sample file is as attached
HTH,
windknife
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks