# Counting duplicate occurences instead of dispaying

#### Calgaryccl

##### New Member
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.

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### FDibbins

##### Well-known Member
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

##### New Member
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

##### Well-known Member

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

Replies
3
Views
117
Replies
2
Views
753
Replies
1
Views
168
Replies
15
Views
2K
Replies
6
Views
201

1,190,810
Messages
5,983,044
Members
439,816
Latest member
aggelos

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back