Re: Fwd: Need help from an Excel guru

[Lauren <lauren -at- writeco -dot- net>]

It seems like your formula still requires a manual process for getting 
the value to fill down.  When the formula is copied and pasted, it will 
reference parallel cells, rather than the cell with data.  So the 
reference column will require the valid data, which still requires a 
fill down of the correct data, which is the manual process that I think 
John is trying to avoid.

What I think needs to occur, is that the extraction tool will need to 
reference the page url and fill it in for each link url.  I do not think 
that Excel is the best place to complete this part of the task.

John, what is the extraction tool?  Does it have any options for 
controlling how it builds the data dump?

Lauren


On 12/16/2010 4:36 PM, Tony Chung wrote:
> As I look back, I made an error. The formula should be:
>
> =if(A2="",C1,A2)
>
> It is slightly manual. The main assumption is that Column A holds the
> ID for the first entry in Column B of a specific type. If Column A is
> not present for a specific Column B item, then Column B must be part
> of the same group as the previous item. In this case, Column C would
> hold the group value, and would only be referenced if the A cell for
> that row is blank.


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

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