Sort

[sheetaldanve]

Hi,
In a report I have 4 sorts eg on columns A, B, C, D. Now I want to underline every time col A's value changes and skip a line every time col C's value changes. Is there any way to achieve this. (I tired to put a break on A and then on C...but that hampers my sort sequence of A, B, C, D)

Col A col B Col C Col D
----- ----- ----- -----
A B C D
A B C DD

A B CC DD
A BB CC DDD

---------------------------
AA BB CC DDDD

AA BB CCC DDDD

----------------------------

 

[nnearing]

Have you tried creating breaks on A, B, and C? This would keep your sort order intact. The break on B could be invisible to the user, because you can uncheck the "remove duplicates" box in the Format Breaks window, as well as the "show header" and "show footer" options.

I hope this helps.

Col A col B Col C Col D
----- ----- ----- -----
A B C D
A B C DD
(break on column C, footer is shown, but is blank)
A B CC DD
(break on column B, no visible change)
A BB CC DDD

-----(break on column A, footer is shown with underline)
AA BB CC DDDD

AA BB CCC DDDD

----------------------------