Hi everyone,

I have a column that consists of the following Measuring Instrumental (M.I) information under column A:

PG
PG
TPG
CMM
CMM
CMM
SRT
CMM
TPG
PG
TM
TM
CMM
SRC
SRT
TPGSC
PGSC
CMM
CMM
CMM
VI

I have 3 objectives:
i) Extract unique value for each M.I type to column B
- I have already achieved it by using the below formula:
=LOOKUP(2,1/((COUNTIF($B$1:B1,$A$2:$A$34)=0)*(COUNTIF($A$2:$A$34,$A$2:$A$34)>1)),$A$2:$A$34)

ii) For PG and TPG, I need to extract the same amount of times they appeared under column A to B, instead of just showing them once.

iii) For VI, I am not intending to extract it.

How do I modify my formula so it achieves all 3 objectives?

Much appreciated.