How to consolidate repeated data from a listBox and show the number of times it was repeated
I have three columns in an excel file. ASSET, DATE, DESCRIPTION. The asset can be repeated lots of times. I would like to hide duplicates and see in another column the number of times the asset was repeated and see these data in a listBox. Every time the same asset number is added in the listBox I want to see incremented the number of times. I have used COUNTIF(range,cell) but I don't know how to hide every time an asset is added.