Hi
Paste the formula below to h2 cell and drag it down
=INDEX(A2:G2,MATCH(TRUE,IF(NOT(ISERROR(A2:G2)),TRUE),0))
After entering formula press Ctrl+Shift+Enter, nbot only enter.
Good luck
Hi
Paste the formula below to h2 cell and drag it down
=INDEX(A2:G2,MATCH(TRUE,IF(NOT(ISERROR(A2:G2)),TRUE),0))
After entering formula press Ctrl+Shift+Enter, nbot only enter.
Good luck
Appreciate the help? CLICK *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks