On Sat, 2 Nov 2013 12:19:14 +0000, mdIsmailkm wrote:

Hi Ron, Thanks for your response. I tried the Array-entered formula, it
worked perfectly. I selected the entire column A in place of 'Fruit' in
your formula.

Glad to help. Thanks for the feedback.

BTW, if you use a smaller range than the entire column, the formula should execute quicker, if that is an issue on your machine. Perhaps $A$1:$A$10000 might be large enough.