Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count words in a column if they are inexact?
Hi Guys,
I have an inventory spreadsheet that has several columns of data. I am trying to count the number of times certain words appear in the columns. I have used the countif and sumif functions before, but have only used them when the words have been exact matches. Now I have words that I'm looking to count that are inexact. The reason why is because they have been entered manually as opposed to electronically. By the way I am looking to do this without using pivot tables. In my experience I have found the count if and sumif functions will accomplish what I am trying to do without using them. The files I tend to work with end up being rather large, so by avioding pivot tables I have seen the size of my files significantly decrease. With that said say in column "A" I am trying to count he number of times the word "Replenishment" occurs but sometimes the person typing will just enter "Replen". So then I would like to use a formula that will look for the first 3 or 5 letters of the word so that I can count the number of times replenishments occured. Other examples would be "Overages" and "Over". As always thank you everyone in advance! Sam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count words in a column if they are inexact?
=COUNTIF(A:A,"Replen*")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sam" wrote in message ups.com... Hi Guys, I have an inventory spreadsheet that has several columns of data. I am trying to count the number of times certain words appear in the columns. I have used the countif and sumif functions before, but have only used them when the words have been exact matches. Now I have words that I'm looking to count that are inexact. The reason why is because they have been entered manually as opposed to electronically. By the way I am looking to do this without using pivot tables. In my experience I have found the count if and sumif functions will accomplish what I am trying to do without using them. The files I tend to work with end up being rather large, so by avioding pivot tables I have seen the size of my files significantly decrease. With that said say in column "A" I am trying to count he number of times the word "Replenishment" occurs but sometimes the person typing will just enter "Replen". So then I would like to use a formula that will look for the first 3 or 5 letters of the word so that I can count the number of times replenishments occured. Other examples would be "Overages" and "Over". As always thank you everyone in advance! Sam |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count words in a column if they are inexact?
Thanks Bob works like a champ!
Bob Phillips wrote: =COUNTIF(A:A,"Replen*") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sam" wrote in message ups.com... Hi Guys, I have an inventory spreadsheet that has several columns of data. I am trying to count the number of times certain words appear in the columns. I have used the countif and sumif functions before, but have only used them when the words have been exact matches. Now I have words that I'm looking to count that are inexact. The reason why is because they have been entered manually as opposed to electronically. By the way I am looking to do this without using pivot tables. In my experience I have found the count if and sumif functions will accomplish what I am trying to do without using them. The files I tend to work with end up being rather large, so by avioding pivot tables I have seen the size of my files significantly decrease. With that said say in column "A" I am trying to count he number of times the word "Replenishment" occurs but sometimes the person typing will just enter "Replen". So then I would like to use a formula that will look for the first 3 or 5 letters of the word so that I can count the number of times replenishments occured. Other examples would be "Overages" and "Over". As always thank you everyone in advance! Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |