Hi Domenic,

Domenic wrote:
Let's assume that the numbers for a row in "Refs" are...

201 202 207 208 210

...and that the corresponding numbers in "Data" are...

7 7 36 35 7

If the criteria is as follows...

=201
<=207
=7

...does it meet the criteria and, therefore, be counted as one?
Yes.

This qualifies as Refs 201-207 x2 Data duplicate
201,202,207,208,210
7,7,36,35,7

This qualifies as Refs 201-207 x2 Data duplicate
201,202,207,208,210
7,35,7,7,7

This does NOT qualify as Refs 201-207 x2 Data duplicate
201,202,207,208,210
7,7,7,35,7

Cheers,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200801/1