software

Hi all

Hoping someone can help - I am creating an evaluation form template and want
just the overall result for a particular set of data ie.

I have listed persons (1-30) across the top row and their response to a
particular question down the first column (Excellent, Very Good, Good, Fair,
Poor). If they reply excellent one gets marked in that cell and the rest of
the cells for that person for that question are blank.

At the end of the row I have a formula to determine the greatest response
i.e. 60% of respondants replied quot;Excellentquot;, the row which has the
quot;Excellentquot; response shows quot;Excellentquot; and the other (i.e. Very Good, Good
etc) will show quot;0quot; (all using formulas, IF statements etc).

I now need to show the final result to another summary worksheet - any
suggestions for a formula that will get rid of the 0's and show just
quot;Excellentquot;, quot;Very Goodquot;, quot;Goodquot;, quot;Fairquot;, or quot;Poorquot;? as they could show in
any row in the column relating to the question. I've been at this all day and
nearly given up - there must be a way!

All help hugely appreciated.
Cheers, fdab66.

Not really sure how your actual set-up is ..

Here's my interp of what you might have over the
cjoint.com/?bzglftPpwm
fdabb66_misc.xls

Could you upload a small sample of your actual* file
and paste the *link* to it in your reply here ?
*sanitized if necessary

Some free filehosts that could be used to upload your sample:
www.flypicture.com/
cjoint.com/index.php
www.savefile.com/index.php

For cjoint.com (it's in French), just click quot;Browsequot; button, navigate to
your folder gt; select the sample file gt; Open, then click the button centred
in the page below (labelled quot;Creer le lien Cjointquot;) and it'll generate the
link. Then copy amp; paste the generated link as part and parcel of your
response here.

But kindly note that no attachments
should be posted *directly* to the newsgroup
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;fdabbquot; gt; wrote in message
...
gt; Hi all
gt;
gt; Hoping someone can help - I am creating an evaluation form template and
want
gt; just the overall result for a particular set of data ie.
gt;
gt; I have listed persons (1-30) across the top row and their response to a
gt; particular question down the first column (Excellent, Very Good, Good,
Fair,
gt; Poor). If they reply excellent one gets marked in that cell and the rest
of
gt; the cells for that person for that question are blank.
gt;
gt; At the end of the row I have a formula to determine the greatest response
gt; i.e. 60% of respondants replied quot;Excellentquot;, the row which has the
gt; quot;Excellentquot; response shows quot;Excellentquot; and the other (i.e. Very Good, Good
gt; etc) will show quot;0quot; (all using formulas, IF statements etc).
gt;
gt; I now need to show the final result to another summary worksheet - any
gt; suggestions for a formula that will get rid of the 0's and show just
gt; quot;Excellentquot;, quot;Very Goodquot;, quot;Goodquot;, quot;Fairquot;, or quot;Poorquot;? as they could show in
gt; any row in the column relating to the question. I've been at this all day
and
gt; nearly given up - there must be a way!
gt;
gt; All help hugely appreciated.
gt; Cheers, fdab66.
Hi Max,

Thanks for getting back to me - I made an abridged version of the
spreadsheet which you can find he cjoint.com/?bzgSct1jcq

Basically I want to insert the result from the data page to the appropriate
place on the summary page.

Thank you so much - I'd given up all hope

Cheers, Fiona.

quot;Maxquot; wrote:

gt; Not really sure how your actual set-up is ..
gt;
gt; Here's my interp of what you might have over the
gt; cjoint.com/?bzglftPpwm
gt; fdabb66_misc.xls
gt;
gt; Could you upload a small sample of your actual* file
gt; and paste the *link* to it in your reply here ?
gt; *sanitized if necessary
gt;
gt; Some free filehosts that could be used to upload your sample:
gt; www.flypicture.com/
gt; cjoint.com/index.php
gt; www.savefile.com/index.php
gt;
gt; For cjoint.com (it's in French), just click quot;Browsequot; button, navigate to
gt; your folder gt; select the sample file gt; Open, then click the button centred
gt; in the page below (labelled quot;Creer le lien Cjointquot;) and it'll generate the
gt; link. Then copy amp; paste the generated link as part and parcel of your
gt; response here.
gt;
gt; But kindly note that no attachments
gt; should be posted *directly* to the newsgroup
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;fdabbquot; gt; wrote in message
gt; ...
gt; gt; Hi all
gt; gt;
gt; gt; Hoping someone can help - I am creating an evaluation form template and
gt; want
gt; gt; just the overall result for a particular set of data ie.
gt; gt;
gt; gt; I have listed persons (1-30) across the top row and their response to a
gt; gt; particular question down the first column (Excellent, Very Good, Good,
gt; Fair,
gt; gt; Poor). If they reply excellent one gets marked in that cell and the rest
gt; of
gt; gt; the cells for that person for that question are blank.
gt; gt;
gt; gt; At the end of the row I have a formula to determine the greatest response
gt; gt; i.e. 60% of respondants replied quot;Excellentquot;, the row which has the
gt; gt; quot;Excellentquot; response shows quot;Excellentquot; and the other (i.e. Very Good, Good
gt; gt; etc) will show quot;0quot; (all using formulas, IF statements etc).
gt; gt;
gt; gt; I now need to show the final result to another summary worksheet - any
gt; gt; suggestions for a formula that will get rid of the 0's and show just
gt; gt; quot;Excellentquot;, quot;Very Goodquot;, quot;Goodquot;, quot;Fairquot;, or quot;Poorquot;? as they could show in
gt; gt; any row in the column relating to the question. I've been at this all day
gt; and
gt; gt; nearly given up - there must be a way!
gt; gt;
gt; gt; All help hugely appreciated.
gt; gt; Cheers, fdab66.
gt;
gt;
gt;

Here's one way, implemented into your sample at:
cjoint.com/?bzhGsbFjGk
fdab66_data_and_summary_1.xls

In sheet: Summary,

Array-enter (press CTRL SHIFT ENTER) in B4,
then copy B4 down to B7:

=INDEX(OFFSET(INDIRECT(quot;Data!Pquot;amp;MATCH(A4,Data!A:A, 0) 1),,,5),MATCH(TRUE,OFFS
ET(INDIRECT(quot;Data!Pquot;amp;MATCH(A4,Data!A:A,0) 1),,,5)lt; gt;quot;quot;,0))

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;fdabbquot; gt; wrote in message
...
gt; Hi Max,
gt;
gt; Thanks for getting back to me - I made an abridged version of the
gt; spreadsheet which you can find he cjoint.com/?bzgSct1jcq
gt;
gt; Basically I want to insert the result from the data page to the
appropriate
gt; place on the summary page.
gt;
gt; Thank you so much - I'd given up all hope
gt;
gt; Cheers, Fiona.
Max - you are a superstar!!!! Thanks very much for your help, it is really
appreciated.

Cheers, Fiona.

quot;Maxquot; wrote:

gt; Here's one way, implemented into your sample at:
gt; cjoint.com/?bzhGsbFjGk
gt; fdab66_data_and_summary_1.xls
gt;
gt; In sheet: Summary,
gt;
gt; Array-enter (press CTRL SHIFT ENTER) in B4,
gt; then copy B4 down to B7:
gt;
gt; =INDEX(OFFSET(INDIRECT(quot;Data!Pquot;amp;MATCH(A4,Data!A:A, 0) 1),,,5),MATCH(TRUE,OFFS
gt; ET(INDIRECT(quot;Data!Pquot;amp;MATCH(A4,Data!A:A,0) 1),,,5)lt; gt;quot;quot;,0))
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;fdabbquot; gt; wrote in message
gt; ...
gt; gt; Hi Max,
gt; gt;
gt; gt; Thanks for getting back to me - I made an abridged version of the
gt; gt; spreadsheet which you can find he cjoint.com/?bzgSct1jcq
gt; gt;
gt; gt; Basically I want to insert the result from the data page to the
gt; appropriate
gt; gt; place on the summary page.
gt; gt;
gt; gt; Thank you so much - I'd given up all hope
gt; gt;
gt; gt; Cheers, Fiona.
gt;
gt;
gt;

You're welcome, Fiona !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;fdabbquot; gt; wrote in message
...
gt; Max - you are a superstar!!!! Thanks very much for your help, it is really
gt; appreciated.
gt;
gt; Cheers, Fiona.