option button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreas - 22 Jun 2007 09:29 GMT

Hi

I need some help! I have a column with results from a survey. The results
are in text but do have a ranking, e.g. the results can be A,B,C,D or E. I
now want to create an option button or similar where I can let the user
choose to cap the results so e.g. the maximum result is a B and then all A
results should show up as B's. Is this possible?

Thanks

Reply to this Message

Barb Reinhardt - 22 Jun 2007 11:05 GMT

You'll need a helper column to do this.

Try something like this:

=IF(B3<=C$1,C$1,B3)

B3 is the survey result, C1 is the "Cap" value.

HTH,
Barb Reinhardt

> Hi
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Earl Kiosterud - 22 Jun 2007 15:46 GMT

OP,

After you use Barb's suggestion, you can make it permanent. Copy the formula cells, then
Paste Special - Values over the originals. Now you won't need the helper column any more.
Be very careful you paste them in the correct place. Alternatively, you can copy the
formula cells, then with the same selection, do the Paste special - Values. Now you can
remove the original column.

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> You'll need a helper column to do this.
>
[quoted text clipped - 16 lines]
>>
>> Thanks

Reply to this Message