Hi,
I was wondering if there was a quick way to count the number of shaded boxes in a column? There are currently no numbers in these boxes and I have about 5-10 columns per worksheet.
I thought I could make a tally of shaded boxes at the bottom of each column or use a formula to put a number in each shaded box and take a count of those? Alternatively sort the data so the shaded boxes are clumped (currently they are spread out).
Unfortunately I am not sure if any of these are possible?
Thanks!
Bookmarks