Hello Friends
In the Column B for the `ABC dmkijtfsh' and if the word `Faco' is there then need to extract the row for specific cells (Column H, K, AA & AT) based on count of word `Fako'.
In attached excel refer the required result in Sheet 2 Light yellow (Fako count 1), light red (Fako count 2) and light green cells (Fako count >2), Sheet 3 shows the after filtered view for better understanding.
Reference Forum :
https://www.excelforum.com/excel-for...ml#post5166502
thanks in advance
Sekar
Bookmarks