Strange thing has happened with this forumula which was working fine in
my original document, but when I added a new column suddenly started
acting up.

Formula is entered in cell CM2 as an array as follows:
{=SUM(IF(BF2:CF2<"",1/COUNTIF(BF2:CF2,BF2:CF2)))}

The 'expected' result should be the number of unique entries in that
range - and it worked as such in an earlier version of the document.
However, since adding a new column to the range (yes, the start/end
columns updated correctly) it has developed an anomaly which means that
if every cell in the range has the same entry, with no blanks, then the
result is 0.999999999999999000000000000000 (9's to the 15th decimal
point).

It still gives the expected result of 1 if there are blank cells in the
range. Ranges where there is more than one unique entry (apart from
blanks) are also unaffected.

Can anyone give a reason why this would be happening?


--
Montrose77
------------------------------------------------------------------------
Montrose77's Profile: http://www.excelforum.com/member.php...o&userid=18191
View this thread: http://www.excelforum.com/showthread...hreadid=571345