RE: [PcTech] Excel ?

[Mark Allen <mallen@xxxxxxxx>]

Duh........
I figured that out after I re-did the formula/cut past thing

Thanks Walden

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of Walden H Leverich III
Sent: Thursday, August 21, 2003 2:25 PM
To: 'PC Technical Discussion for iSeries Users'
Subject: RE: [PcTech] Excel ?


Do you have =A1 or =$A$1 (note the $). If you fill the field by clicking
you get $a$1, you need it without the $ so that the references change. 

------------
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 1:44 PM
To: 'PC Technical Discussion for iSeries Users'
Subject: RE: [PcTech] Excel ?


Paste Special doesn't adjust cell referencing to on conditional
formatting, always uses A1

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of Walden H Leverich III
Sent: Thursday, August 21, 2003 12:22 PM
To: 'PC Technical Discussion for iSeries Users'
Subject: RE: [PcTech] Excel ?


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.
_______________________________________________
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.

_______________________________________________
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.
_______________________________________________
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.