LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default conditional headings

Assume the user enters a value between 1 and 12 inclusive into cell
A1. You could use this in another cell to return your heading:

=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine","Ten","Eleven","Twelve" )

Of course, you should substitute the headings you want for the
"numbers".

Hope this helps.

Pete

On Jan 11, 7:00*pm, excel help acct <excel help
wrote:
I need to populate a heading on an excel spreadsheet based on a value keyed
by a user. *It can be one of 12 values keyed in. *How can I code the heading
to appear based on the chouice selected by the user?




 
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
Headings Dena B Excel Discussion (Misc queries) 4 August 11th 05 04:41 PM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM
Headings Craig Pfaff Excel Discussion (Misc queries) 1 January 3rd 05 08:09 PM
headings KSH Excel Worksheet Functions 3 November 14th 04 03:42 AM
Excel row headings vandan Excel Worksheet Functions 1 November 2nd 04 12:23 PM


All times are GMT +1. The time now is 07:03 AM.

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"