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

Conditional Formatting - Drawing Lines Between Sorted Groups
 

=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

Conditional Formatting - Drawing Lines Between Sorted Groups
 

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