Calgaryccl
New Member
- Joined
- Nov 26, 2016
- Messages
- 2
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!
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!