PDA

View Full Version : [SOLVED] Tricky COUNT(IF(S)) problem



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

blackie42
12-02-2014, 03:25 AM
Unique eference in Col A so highlighted lines are the duplicates.

Count should be 18 not 20


12575