Computing a cumulative while ignoring duplicates

[Apriljustice]

Hi all,

A few days ago, I posted a topic about counting the total number of charcters in a single cell, while ignoring duplicates. That post is located here ([URL="http://http://www.excelforum.com/excel-2007-help/714780-constructing-a-formula-that-counts-distinct-words-in-a-single-cell.html"]

I was given this formula.
=COUNT(FIND(" "&ROW(INDIRECT("1:32"))&","," "&G2&","))

Then, CTRL+SHIFT+ENTER

This formula works beautifully, but now I need to modify it slightly so that it can count all of the unique entries in multiple worksheets. So now it looks more like this

=COUNT(FIND(" "&ROW(INDIRECT("1:32"))&","," "&Jan!G2&Feb!G2&Mar!G2&Apr!G2&May!G2&Jun!G2&Jul!G2&Aug!G2&Sep!G2&Oct!G2&Nov!G2&Dec!G2&","))

Then, CTRL+SHIFT+ENTER

It works ok, until "Jul" then after Jul, the count is off by 2. The total number of Unique should not exceed 32.

I'm know this is confusing but any help is appreciated. I'll try to clarify questions as best as I can. Thanks!

April


http://www.excelforum.com/excel-2007-help/714780-constructing-a-formula-that-counts-distinct-words-in-a-single-cell.html


MOD: thread moved to Worksheet Functions Forum from Tips & Tutorials (non question forum) - please post in most appropriate forum going forward