blackie42
12-01-2014, 09:05 AM
Hi,
Trying to figure out how I would go about discounting duplicates from the following
COL A COL B COL C COL D
AVB1 B Month CAT 1
AVB1 B Month CAT 1
AVA1 A Month CAT 1
Using B column with mid function to get 3rd letter in col A (could be A or B).
So the count would be 1 AVB1 & 1 AVA1 as AVB1 is duplicated
Any help appreciated
thanks
Trying to figure out how I would go about discounting duplicates from the following
COL A COL B COL C COL D
AVB1 B Month CAT 1
AVB1 B Month CAT 1
AVA1 A Month CAT 1
Using B column with mid function to get 3rd letter in col A (could be A or B).
So the count would be 1 AVB1 & 1 AVA1 as AVB1 is duplicated
Any help appreciated
thanks