Re: Fwd: Need help from an Excel guru

Subject: Re: Fwd: Need help from an Excel guru
From: John Posada <jposada99 -at- gmail -dot- com>
To: Tony Chung <tonyc -at- tonychung -dot- ca>
Date: Thu, 16 Dec 2010 20:58:25 -0500

When I ran the first version, it would duplicate it one row down, but
all subsequent rows would be zero filled.

I completed the work before I saw the new version, so I don't know how
well it would have worked.

Thanks anyway, Tony

>> You sent it to the list, too, and I am interested in learning how well
>
> Why yes, I guess I did. I didn't think I did that. Oh well.
>
>> this works with John's spreadsheet, since it seems very simple and
>> useful, but I am uncertain about how your formula will work.
>
> 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.
>
> So, in a table (ignore faulty formatting due to proportionally spaced type:
>
> ID     Desc    Formula
> xxxx  Item A  =if(A2="",C1,A2) | A2 is not blank, so display "xxxx"
>         Item B  =if(A3="",C2,A3) | A3 is blank, so display C2, which
> holds "xxxx")
>         Item C  =if(A4="",C3,A4) | A4 is blank, so display C3, which
> also holds "xxxx")
> yyyy  Item D  =if(A5="",C4,A5) | A5 is not blank, so display "yyyy"
>
> etc...
>
> Serves me for trying to answer questions on my iPhone.

--
John Posada
http://jposada.zenfolio.com/
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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
Fwd: Need help from an Excel guru: From: Tony Chung
Re: Fwd: Need help from an Excel guru: From: Lauren
Re: Fwd: Need help from an Excel guru: From: Tony Chung

Previous by Author: Re: Need help from an Excel guru
Next by Author: if you had 60 seconds to evaluate a support web page, what would you look for
Previous by Thread: Re: Fwd: Need help from an Excel guru
Next by Thread: MadCap Flare - footnotes with hyperlinks


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


Sponsored Ads