Conditional Formatting - Drawing Lines Between Sorted Groups

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

=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

Hi Ardus,

>HTH

It most certainly did the job! Thank you ever so much for your help.

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

I just absoluted the columns.

Cheers
Sam

Ardus Petus wrote:
>=AND(A1<>A2,COUNTIF(A:A,A1)>1)
>
>HTH
>--
>AP
>
>> Hi All,
>>
>[quoted text clipped - 6 lines]
>> Cheers,
>> Sam

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