LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
AlwaysAAngel
 
Posts: n/a
Default Assigning values to a Validation Menu


I'm trying to do this thing on Excel where I have a list of values that
are being summed at the bottom of the page. Thats not a problem. The
problem I'm having is that one of the cells is a pull down list
(Validation) and I need to set it up so each of the choices (eg. A-1,
B-2,...) has a specific value associated with it that will be added in
with the rest of the sum. Anyone know how I can do this?


--
AlwaysAAngel
------------------------------------------------------------------------
AlwaysAAngel's Profile: http://www.excelforum.com/member.php...o&userid=27284
View this thread: http://www.excelforum.com/showthread...hreadid=467915

 
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
Zero values in a log chart Joelle_Smith Charts and Charting in Excel 2 May 8th 23 03:42 AM
Assigning text values to numeric fields ab565 Excel Discussion (Misc queries) 1 August 11th 05 10:49 PM
Validation function under DATA Menu Asanny Excel Discussion (Misc queries) 2 March 16th 05 03:10 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 02:51 PM.

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

About Us

"It's about Microsoft Excel"