LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew
 
Posts: n/a
Default Question regarding : CHAR(64+COLUMN())

I have indirect formulaue in various cells that refer to certain columns in a
very large spreadsheet using the above formulae . The formulae above is
pasted along row 1 and allows me to insert colums, drag and drop data etc but
still feed data into the solution. My problem is that after I reach column Z
the above formulae defaults to symbols and then to lower case letters again.
This does not work with my indirect formulae collecting info from columns
after row Z. How can I change the above formulae to continue with letters (?)
after Z ? Any assistance appreciated.
 
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
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Newbie Question Column Adding Please Help Tom Grassi New Users to Excel 2 December 19th 05 07:00 PM
IF/AND/OR/DATEIF Issue...sorry...long post... EDSTAFF Excel Worksheet Functions 1 November 10th 05 12:28 AM
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM


All times are GMT +1. The time now is 04:02 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"