Hello Geniuses,
=IFERROR(LOOKUP(2,1/(F7:BF7<>""),$F$2:$BF$2),"") works in Excel but I can't get it to run in google sheets where it needs to function inevitably. Formula references max header column when max row cell has content. Excel file attached.
Thank You!
Try this
Enter as written
Formula:
Please Login or Register to view this content.
Last edited by AlKey; 08-27-2017 at 06:27 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks