how can i have the total of cells that include number in a row
i need your help
i try to do this one in vertical mode but i can't
i would like to explain me in a excel sheet
how can i have the total of cells that include number in a row
like
i have numbers and letters in a row
i would like to have a result in a new column how many cells include only numbers in a row
a b c d e f g h i j k l m n o
1 1 1 1 2 1 2 6 a c 1 3 4 5 1 a
2
3
so the right result is 7 numbers in a row
can you help me with this one
thanks in advance
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
i got error AT COLUMNOriginally Posted by martindwilson
can you attach me an excel file?
thanks
Last edited by littlekid; 02-24-2010 at 09:07 AM.
there you go formula is in a4
Re: how can i have the total of cells that include number in a row
thankssssssssssssssssssss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks