I'm finding that having so many formulas
calculating at one time is bogging down my worksheet.

I only suggested one formula! But reading between the lines I think I know
what you did. But even then, 100 of those formulas shouldn't be very
resource expensive.

So, what you want is to count duplicates in general rather than duplicates
based on a specific criteria (which is how I interpreted your post)

Hmmm....

Well, the only way I can see how to do this requires a helper column where
you concatenate each row of data:

H2 = =C2&D2&E2&F2&G2

Copy down 100 rows, then, to count the dupes:

=SUMPRODUCT(--(H2:H101<""),--(COUNTIF(H2:H101,H2:H101)1))

Biff

"yungexec" wrote in
message ...

Biff,

Thanks for the information! I'm finding that having so many formulas
calculating at one time is bogging down my worksheet. Tell me if this
is possible. I still need to count duplicate ranges. Lets say I have
the following 100 rows of data that are similar to the following 5
rows:

1,2,4,5,7
2,3,5,7,8
1,2,4,5,6
5,7,9,11,12
1,2,4,5,7

I would like to count how many duplicate ranges containing all 5
numbers(2). How can I get a total count into one cell so that my
worksheet doesn't get bogged down? Again, I'm just looking to count
the total number of duplcate ranges in 100 rows of data.


--
yungexec
------------------------------------------------------------------------
yungexec's Profile:
http://www.excelforum.com/member.php...o&userid=22593
View this thread: http://www.excelforum.com/showthread...hreadid=565444