=AND(A1<A2,COUNTIF(A:A,A1)1)

HTH
--
AP

"Sam via OfficeKB.com" <u4102@uwe a écrit dans le message de news:
60d2b70288bf9@uwe...
Hi All,

Can anyone provide a Conditional Formula that can draw a line between Rows
of
sorted groups of data BUT only draw the line if, or when the group
contains
more than one Row (of the same data) in its sorted group.

Cheers,
Sam

--
Message posted via http://www.officekb.com