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



No problem. I know I've spent many hours scratching my head about a cell
saying to myself "that HAS TO WORK" just to find a stupid $ somethere. On
the otherhand, I've done the exact reverse when I'm missing a $ I should
have.

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


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.

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