option button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
--
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...
-----------------------------------------------------------------------
 
Back
Top