LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Assigning values to drop-down list options

I'm not even sure if Excel can do this...

I have a worksheet with 5 different drop-down lists on it (each with several
options to select from). I want to be able to assign each option a value so
that I can create a cell/formula that will average the values selected.

Can I do this in Excel? How????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list with different values. Honey Excel Worksheet Functions 3 January 14th 07 08:24 PM
Mask Drop Down List values DangerMouse Excel Discussion (Misc queries) 1 June 12th 06 01:05 PM
How do I delete the drop down list of header / footer options in e Progress Finance Excel Discussion (Misc queries) 1 December 1st 05 06:49 PM
validation list with drop down list of options?? luke013 Excel Worksheet Functions 1 August 31st 05 01:16 PM
How do I set up a drop down box in Excel with a list of options f. Debbie C Excel Discussion (Misc queries) 1 March 31st 05 12:16 PM


All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"