| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Words and dates...
Someone very helpful helped me with a formula and hope maybe they can help me
once agian. they gave me the following formula, which searched for text within a column. What do I need to do to adjust that to choose specific text within certain dates... =COUNTIF(C:C,"RXL") it works great... but I came up with the problem of needing only the Rxl's between certain dates. This formula calculates them all. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Words and dates...
Let's assume that the dates are in column B. Try this:
=SUMPRODUCT(--(B1:B100DATE(2007,1,1)),--(B1:B100<DATE(2008,1,1)),--(ISNUMBER(SEARCH("RXL",C1:C100)))) This will give youdates between 1/1/2007 and 1/1/2008 that contain RXL in column C. -- HTH, Barb Reinhardt "m4d Ir15h" wrote: Someone very helpful helped me with a formula and hope maybe they can help me once agian. they gave me the following formula, which searched for text within a column. What do I need to do to adjust that to choose specific text within certain dates... =COUNTIF(C:C,"RXL") it works great... but I came up with the problem of needing only the Rxl's between certain dates. This formula calculates them all. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
![m4d Ir15h[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
