Hi Everyone,
I have a data with 6 columns that contains various texts. These are a combination of either "Loc" with incremental value & "T" or "O". What I need is to count all unique values containing "T" and plot it in another column named "T", and count all unique values containing "O" and plot it in column named "O". I need formula for these two columns (Column T and O). Thank you.
Sample data:
RESULT
D1 D2 D3 D4 D5 D6 T O
Loc1-T Loc2-T Loc1-O Loc2-O Loc2-O 2 2
Loc1-T Loc1-T Loc1-O Loc2-O Loc1-O Loc3-O 1 3
Loc2-T Loc2-T Loc2-O Loc3-O Loc3-O 1 2
Bookmarks