count merge cells as 1 if the same value

count the merged cells and treat as 1 if the value in is same, for column J5:J798 - let say some of the cell has a value of "B" and some of the are merged (2, 3, 4 or more rows) i need to count as 1 if merged.