- I think this should work with
Excel 2003
- Barcode count values placed in a new worksheet named "Unique"
- making it easy to delete that worksheet if you then copy them elsewhere
- run in attached workbook with
{CTRL} k
How it works:
- sheet containing barcodes activated to set the correct range of values to use
- new worksheet added
- barcode values attributed to new sheet (more efficient than copy/paste) starting at A2
- new values sorted
- TWO counts calculated for each barcode (total and cumulative to each row)
- total count placed in columnB (BUT only against first occurence of barcode - ie when cumulative count = 1)
- rows where cell in columnB is BLANK deleted (identified using SpecialCells property)
Any questions?
- you must ask if there is anything in the code that you do not fully understand
- if you need further help in taking things to the next stage let me know
Attachment 555771
Bookmarks