Hello friends,
The attachment here includes the CDs listed in my itunes.
I need a formula that would go thru. column J, and pick the number of CDs that fall between decades 1970-1980, 1980-1990, 1990-2000,etc.
* One condition though, counting should be unique, and ignore repeated rows with same year and the same CD name.
Your help is truly appreciated in advance!
Nawaf