Hi All,
I need a formula to get the count of a particular text appearing in the cell as follows. (Problem is, the sentence may not be in order or alike)
In Cell A1 i have the following text: work is done Mouse is replaced
In Cell A2 i have the following text: CPU and Mouse Replaced
In Cell A3 i have the following text: keyboard has replaced now it's working fine.
In Cell A4 i have the following text: CPU has replaced now it's working fine.
Bascially i need a formula so that i can get the total number of items replaced. (Something like contains) - you can consider Key words as "<items>" and "Replaced"
Mouse Replaced: 2 (From A1 & A2) - Need Formula??
CPU Replaced: 2 (From A2 & A4) - Need Formula??
Keyboard Replaced: 1 (A3) - Need Formula??
Thanks!!
I need a formula to get the count of a particular text appearing in the cell as follows. (Problem is, the sentence may not be in order or alike)
In Cell A1 i have the following text: work is done Mouse is replaced
In Cell A2 i have the following text: CPU and Mouse Replaced
In Cell A3 i have the following text: keyboard has replaced now it's working fine.
In Cell A4 i have the following text: CPU has replaced now it's working fine.
Bascially i need a formula so that i can get the total number of items replaced. (Something like contains) - you can consider Key words as "<items>" and "Replaced"
Mouse Replaced: 2 (From A1 & A2) - Need Formula??
CPU Replaced: 2 (From A2 & A4) - Need Formula??
Keyboard Replaced: 1 (A3) - Need Formula??
Thanks!!
Last edited: