countryfan_n
05-16-2009, 02:39 AM
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
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