Dear All,
I have single cell having remarks of work done. I need to extract the data based on two conditions. I'm already using below formula which returns the word in cell but not fulfilling the condition I need.
Relay & Capacitor replaced
=IF(ISNUMBER(SEARCH("Relay",$T64)), "Relay", "")...