"RagDyeR" <[email protected]> wrote in message news:...
Try this:
=SUMPRODUCT(--(LEN(A1:Z1)>2))
And copy down as needed.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"sks1379" <[email protected]> wrote in
message news:[email protected]...
Hi,
My requirement is thus...
I have multiple rows with one word in each cell...at the end of each
row i need to find the number of words in that particular row whose
length is greater than 2.
Any thoughts please?
Thanks
Kiran.
--
sks1379
------------------------------------------------------------------------
sks1379's Profile:
http://www.excelforum.com/member.php...o&userid=26954
View this thread: http://www.excelforum.com/showthread...hreadid=401729
Bookmarks