Fwd: Need help from an Excel guru

Subject: Fwd: Need help from an Excel guru
From: Tony Chung <tonyc -at- tonychung -dot- ca>
To: TECHWR-L <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Thu, 16 Dec 2010 12:26:34 -0800

I sent this directly to John but it might have gotten trapped in his spam
blocker.

-Tony



Begin forwarded message:

*From:* Tony Chung <tonyc -at- tonychung -dot- ca>
*Date:* 15 December, 2010 18:40:25 PST
*To:* John Posada <jposada01 -at- yahoo -dot- com>
*Cc:* "List, Techwriter" <techwr-l -at- lists -dot- techwr-l -dot- com>
*Subject:* *Re: Need help from an Excel guru*

Hi John,

The quick and dirty would be to copy this formula into the last
column, then copy the column and paste as values over the first
column:

=if(A2="",A1,A2)

Let the cell reference change to be relative to the current row.

-Tony



On 2010-12-15, at 18:00, John Posada <jposada01 -at- yahoo -dot- com> wrote:

Hi, guys...long time...


I find myself with a task where I have an Excel spreadsheet with about 5,000

rows. It is a database of URLs from my knowledgebase.


It looks similar to the following:



xxxxx erergkerg

juwe

ejrhghjkerg

zzzzz ueeefjvbhfb

jwerfjerjef

erfpiquer

yyyyy ehqerf

wjkf;kjqbb

kjkf;kjb


You get the idea.


I want to automate the process of copying each string in column one to each

row below it until the value changes, then copy that one until it changes,

to the end.


I would end up with:


xxxxx erergkerg

xxxxx juwe

xxxxx ejrhghjkerg

zzzzz ueeefjvbhfb

zzzzz jwerfjerjef

zzzzz erfpiquer

yyyyy ehqerf

yyyyy wjkf;kjqbb

yyyyy kjkf;kjb


I'm aware that I can highlight the string and all the empty ones below it

and press CTRL-d, but I have about 1600 sets. Is there was a way automate

it?


Thanks


--

John Posada

Senior Technical Writer

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


Create and publish documentation through multiple channels with Doc-To-Help.

Choose your authoring formats and get any output you may need. Try

Doc-To-Help, now with MS SharePoint integration, free for 30-days.

http://www.doctohelp.com


---

You are currently subscribed to TECHWR-L as tonyc -at- tonychung -dot- ca -dot-


To unsubscribe send a blank email to

techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com

or visit
http://lists.techwr-l.com/mailman/options/techwr-l/tonyc%40tonychung.ca



To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit

http://www.techwr-l.com/ for more resources and info.


Please move off-topic discussions to the Chat list, at:

http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create and publish documentation through multiple channels with Doc-To-Help.
Choose your authoring formats and get any output you may need. Try
Doc-To-Help, now with MS SharePoint integration, free for 30-days.
http://www.doctohelp.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat


Follow-Ups:

References:
Re: Need help from an Excel guru: From: Tony Chung

Previous by Author: Re: Need help from an Excel guru
Next by Author: Re: Fwd: Need help from an Excel guru
Previous by Thread: Re: Need help from an Excel guru
Next by Thread: Re: Fwd: Need help from an Excel guru


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads