| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT: Search for text in column and count by month
Hi I am trying to find the cells containing the text defect and wanna count how many times it occurs a month. Column G contains the defects text and Column S contains the month. Eg: Column G : Column S Defect1 occured and resulted in failure : Jan-05 Defect1 and Defect2 occurred and resulted in failure : Feb-05 Defect1 and Defect2 occurred and resulted in failure : Feb-05 So my result should be: Jan-05 Defect1 - 1 Feb-05 Defect1 - 1 Feb-05 Defect2 - 2 -- saras ------------------------------------------------------------------------ saras's Profile: http://www.excelforum.com/member.php...o&userid=33434 View this thread: http://www.excelforum.com/showthread...hreadid=532502 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
