Hi,
I'm trying to do a "countifs" formula that has to meet a few criteria and there is one criteria I'm not sure how to write (the other criteria are straight forward)
the criteria is if I find certain text in a cell but the text could be anywhere in the cell... at the start at the end in the middle..
For example if I'm looking for "VEA 01" how do I get it to count it if is appears somewhere in the cell
Example cell 1 = "VEA 05 VEA 03 VEA 01"
Example cell 2 = "VEA 01 VEA 06 VEA 04"
Example cell 3 = "VEA 05 VEA 01 VEA 04"
Example cell 4 = "VEA 05 VEA 01"
Example cell 5 = "VEA 01"
In all of the above examples VEA 01 has appeared somewhere in the cell so I want it counted..
I'm trying to do a "countifs" formula that has to meet a few criteria and there is one criteria I'm not sure how to write (the other criteria are straight forward)
the criteria is if I find certain text in a cell but the text could be anywhere in the cell... at the start at the end in the middle..
For example if I'm looking for "VEA 01" how do I get it to count it if is appears somewhere in the cell
Example cell 1 = "VEA 05 VEA 03 VEA 01"
Example cell 2 = "VEA 01 VEA 06 VEA 04"
Example cell 3 = "VEA 05 VEA 01 VEA 04"
Example cell 4 = "VEA 05 VEA 01"
Example cell 5 = "VEA 01"
In all of the above examples VEA 01 has appeared somewhere in the cell so I want it counted..