Counting duplicate occurences instead of dispaying

[Calgaryccl]

Hello all,

I am not very good with Excel and have managed to use reading this and other forums to get this far, but am now stumped.

I want my spreadsheet to use Colum C to count occurrences in column B instead of displaying them in Column B.



Column A is input by scanning in a barcode and displays it in regular font


Column B displays column A in barcode font

As of now, Column C will count the occurrences, but still shows all of the duplicates in column A and B.


When I scan in a duplicate barcode to Column A, I would like it to count the occurrence into Column C instead of populating Column A with the duplicate occurrence.

If that isn't possible, I would settle for Column B not populating the barcode.

Please help!

 

[FDibbins]

Hi, welcome to the board

If I understand you correctly (not sure I do), perhaps this in B, assuming your data starts in A1...

=if(countif($A$1:A1,A1)>1,"",A1)
copied down

 

[Calgaryccl]

Hi, welcome to the board

If I understand you correctly (not sure I do), perhaps this in B, assuming your data starts in A1...

=if(countif($A$1:A1,A1)>1,"",A1)
copied down

Thank you for such a quick response.

The challenge with entering any formula into Colum B, is that there is already a formula to add the "*" sign at the beginning and end of the data....It's he only way a barcode scanner will read the barcode font once the spreadsheet is printed. this formula automatically adds the asterisk ----- ="*"&A2&"*"


COLUMNA COLUMNB COLUMNC
12345 12345(Barcode font) 2
12345 12345(Barcode font) 2
54321 54321(Barcode font) 1



I would like the second row in this example to not populate at all once it recognizes that it's a repeat, but instead just show the count in column C.

 

[FDibbins]

So then just add your formula to my suggestion...

=if(countif($A$2:A2,A2)>1,"",="*"&A2&"*")