|
calculate the number of words in a row whose length is greater than 2
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 |
something like this - count # of cells in a3:d3 with length 2 =SUMPRODUCT((LEN(A3:D3)2)*1) -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=401729 |
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" wrote in message ... 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 |
"RagDyeR" 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" wrote in message ... 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 |
Hi, Thanks a lot for both the response...as both seem to be working....look forward to bombarding u guys with q's again.. ;) Thanks again.. Regds Kiran. -- sks1379 ------------------------------------------------------------------------ sks1379's Profile: http://www.excelforum.com/member.php...o&userid=26954 View this thread: http://www.excelforum.com/showthread...hreadid=401729 |
HTH Note you could get a count of a range of lengths by =SUMPRODUCT((LEN(A3:D3)2)*(LEN(A3:D3)<XXX)) where XXX is the upper limit of length you want to count, such as 5 -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=401729 |
| All times are GMT +1. The time now is 05:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com