LinkBack URL
About LinkBacks
i think
=MAX(FREQUENCY(IF(ISNUMBER(A1:P1),COLUMN(A1:P1)),IF(ISTEXT(A1:P1),COLUMN(A1:P1))))
array entered with ctr+shift+enter should do it
i think
=MAX(FREQUENCY(IF(ISNUMBER(A1:P1),COLUMN(A1:P1)),IF(ISTEXT(A1:P1),COLUMN(A1:P1))))
array entered with ctr+shift+enter should do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks