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.
Bookmarks