| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creat a formula to calculate working hrs according to number of da | Excel Worksheet Functions | |||
| Number Field to Text or Words | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| how can i convert a number in words? | Excel Discussion (Misc queries) | |||
| Calculate the number of workdays between 2 dates | Excel Worksheet Functions | |||
Hybrid Mode
