Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurance of a leter in a text string
Needing to make a simple billboard sign making sheet.
The operator would enter the sign's current text and in another cell enter the new text. The sheet would show the number of each letter used in the current sign and compare to that needed in the new sign and show those letters need to complete the new sign. That way the workers would only have to carry the necessary letters up the ladder to complete the new billboard. Thanks for any help you can provide. -- --------------------------------- --- -- - Posted with NewsLeecher v3.95 Beta 1 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurance of a leter in a text string
Let's assume A1 contains the text of the current sign and B1 contains the
text of the new sign. Enter a couple of column headers in say I1 and J1: I1 = Current J1 = New Enter the letters A, B, C, D, .... Z in cells H2:H27 Enter this formula in I2: =LEN(A$1)-LEN(SUBSTITUTE(UPPER(A$1),$H2,"")) Copy across to J2 If the result in column J is greater than the result in column I you need the difference. You can put another formula in column K to get the difference but you can probably figure out how to do that. -- Biff Microsoft Excel MVP "justaman" wrote in message ... Needing to make a simple billboard sign making sheet. The operator would enter the sign's current text and in another cell enter the new text. The sheet would show the number of each letter used in the current sign and compare to that needed in the new sign and show those letters need to complete the new sign. That way the workers would only have to carry the necessary letters up the ladder to complete the new billboard. Thanks for any help you can provide. -- --------------------------------- --- -- - Posted with NewsLeecher v3.95 Beta 1 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurance of a leter in a text string
Left out something!
Enter this formula in I2: Copy across to J2 Then select both I2 and J2 and copy down to row 27. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Let's assume A1 contains the text of the current sign and B1 contains the text of the new sign. Enter a couple of column headers in say I1 and J1: I1 = Current J1 = New Enter the letters A, B, C, D, .... Z in cells H2:H27 Enter this formula in I2: =LEN(A$1)-LEN(SUBSTITUTE(UPPER(A$1),$H2,"")) Copy across to J2 If the result in column J is greater than the result in column I you need the difference. You can put another formula in column K to get the difference but you can probably figure out how to do that. -- Biff Microsoft Excel MVP "justaman" wrote in message ... Needing to make a simple billboard sign making sheet. The operator would enter the sign's current text and in another cell enter the new text. The sheet would show the number of each letter used in the current sign and compare to that needed in the new sign and show those letters need to complete the new sign. That way the workers would only have to carry the necessary letters up the ladder to complete the new billboard. Thanks for any help you can provide. -- --------------------------------- --- -- - Posted with NewsLeecher v3.95 Beta 1 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurance of a leter in a text string <-- Thanks loads
Let's assume A1 contains the text of the current sign and B1 contains the
text of the new sign. Enter a couple of column headers in say I1 and J1: I1 = Current J1 = New Enter the letters A, B, C, D, .... Z in cells H2:H27 Enter this formula in I2: =LEN(A$1)-LEN(SUBSTITUTE(UPPER(A$1),$H2,"")) Copy across to J2 If the result in column J is greater than the result in column I you need the difference. You can put another formula in column K to get the difference but you can probably figure out how to do that. -- Biff Microsoft Excel MVP "justaman" wrote in message ... Needing to make a simple billboard sign making sheet. The operator would enter the sign's current text and in another cell enter the new text. The sheet would show the number of each letter used in the current sign and compare to that needed in the new sign and show those letters need to complete the new sign. That way the workers would only have to carry the necessary letters up the ladder to complete the new billboard. Thanks for any help you can provide. -- --------------------------------- --- -- - Posted with NewsLeecher v3.95 Beta 1 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - -- --------------------------------- --- -- - Posted with NewsLeecher v3.95 Beta 1 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a string of nth occurance & pick next 3 words | Excel Worksheet Functions | |||
Count Occurance of Text/Word in a Range | Excel Discussion (Misc queries) | |||
help to find a string for 4th occurance | Excel Worksheet Functions | |||
Find last occurance of character in text string | Excel Worksheet Functions | |||
Occurance Number Within a String | Excel Discussion (Misc queries) |