Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif, Index, Match... not sure which to use
I need to be able to count how times the word 'CNC' occurs in column B, only
when the value in column A equals 'Assembly'. The text in column A is exact, but the text in column B needs to search for 'CNC' using wildcards, because there are many words in each cell in column B; and sometimes there is nothing in column B. I'm not sure which function to use or combination of functions to use for this. Here is what some of the data looks like: Column A Column B Assembly Assembly Communication Assembly Ergonomics; Safety Ergonomics Assembly More safety related training; Safety Ergonomics Assembly Assembly Better ergonomics; Safety Ergonomics Assembly Ergonomics; Safety Ergonomics; computer Assembly None Assembly None Assembly Computer Functioning; Computer Systems; Communication Assembly Assembly Service school for the repair group Assembly Assembly Assembly Assembly Null More people skill; giving & receiving feedback; presenting goals ideas, etc. Null AS400; Computer Systems; safety Other Business Process, Manufacturing Machining CNC Machining Machining Basic machining; I need to at least be able to talk the language; CNC/Machining/Programming GPMG Gear Training Reman Salaried Assembly Computer training to properly perform point duties; Computer Systems Other People Skills Other Working with Al Salentine; computer Machining Quality Assembly Quality -- Thank you, Amy@H-D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |