Forum Discussion
Sioren
Jul 02, 2019Copper Contributor
Hiding Data in Excel - Need help!
This is a current spreadsheet I am working on - it is to record book sales. All the repeating data, I want to make blank until the blank areas are filled in. Is this possible? I have tried the condit...
SergeiBaklan
Jul 03, 2019Diamond Contributor
You may hide repeating items with conditional formatting and count only unique inventory numbers with one of the formulas from here https://exceljet.net/formula/count-unique-values-in-a-range-with-countif