Count and show the occurrence of a text only if present

With validation list in column D try these array-entered formulas. In B13 and filled down until you get blanks.

Formula:

Please Login or Register  to view this content.

and in C13 filled down until you get blanks.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Row\Col	A	B	C	D	E
1	Codes
2	m			apple
3	s			banana
4	l			kiwi
5	b			lime
6	m			mango
7	p			pear
8	y			strawberry
9	z
10	p
11	m
12
13		mango	3		In B13
14		pear	2		{=IFERROR(INDEX($D$2:$D$8,SMALL(IF(COUNTIF($A$2:$A$11,LEFT($D$2:$D$8))>1,ROW($D$2:$D$8)-MIN(ROW($D$2:$D$8))+1),ROWS($1:1))),"")}
15					in C13
16					{=IFERROR(INDEX(COUNTIF($A$2:$A$11,LEFT($D$2:$D$8)),SMALL(IF(COUNTIF($A$2:$A$11,LEFT($D$2:$D$8))>1,ROW($D$2:$D$8)-MIN(ROW($D$2:$D$8))+1),ROWS($1:1))),"")}

You are welcome.
Unfortunately my browser will not permit me to see *.png files posted here.

You have the option of uploading a representative Excel workbook on this forum.

If you are interested click on FAQ, then click on Reading and posting Messages under the Board FAQ. There are more lists of options including RE: attachments. Click that and follow the instructions.