× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Conditional formatting will do what you need.

Click on A2
Goto Format|Conditional Formatting
Condition is "Cell Value Is" "equal to" "=a1"
Click Format and set the font color to white
Click OK and OK again.

Now Copy A2
Select A3...Awhatever

Paste Special and select Formats

The duplicate values will be there, but since they are in a white font you
won't see them on the screen on on paper.

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: Mark Allen [mailto:mallen@xxxxxxxx] 
Sent: Thursday, August 21, 2003 11:12 AM
To: 'PC Technical Discussion for iSeries Users'
Subject: [PcTech] Excel ?



Is there a way to do this in Excel?
        Col 1   Col 2
Row 1 AAAA      1234
Row 2 AAAA      5678    
Row 3 AAAA      2222
Row 4 AAAA      5874
Row 5 BBBB      1234
Row 6 BBBB      5678

What I want is when it prints to show like this

        Col 1   Col 2
Row 1   AAAA    1234
Row 2           5678
Row 3           2222
Row 4           5874
Row 5   BBBB    1234
Row 6           5678

i.e. if Col A has same value as the row above it don't print/make blank
Col A

_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.