Try
=INT(LOOKUP(99,3:3,COLUMN(3:3))/3)
Assuming none of the numbers will be larger than 99.
Try
=INT(LOOKUP(99,3:3,COLUMN(3:3))/3)
Assuming none of the numbers will be larger than 99.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks