All i need the count of names from cell A in cell B, like in attached sheet its showiing 3 against yellow colored Ram (bcoz ram is 3 times there in column), similarlyit should show the count for Robin, Bharat and Mac. I have done it mannually but i have lot of data so i need a formulae for it. kin
Bookmarks