LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default Autofilling Alpha-Numeric numbers with column headers

Edited to clarify question...

I have to complete an unfiltered table using formulas....The columns go from 1-16 and the rows g from A-Z. In row A it goes....1A, 2A,3A,4A all the way to column 16, which is 16A. The same happens for Row B. I have to create a formula to fill in the rest of the rows/columns with the same sequence. What formula do I use? Or does this require a macro formula? I'm really stumped on this one and have to have this compete by Monday morning...HELP!

Last edited by JackofAllTrades : June 3rd 12 at 02:26 PM
 
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
Alpha with numeric and numeric only numbers in a column rciolkosz Excel Discussion (Misc queries) 6 September 18th 09 09:31 PM
How can I change column headers from numeric to alpha? Trish Excel Discussion (Misc queries) 2 October 23rd 07 08:11 PM
Split the numbers in a alpha numeric case Jp Excel Discussion (Misc queries) 5 April 7th 06 09:29 PM
change excel auto column headers from numeric to alpha MarcieinHawaii Excel Discussion (Misc queries) 2 February 14th 06 09:22 PM
Extract Numbers from Alpha-Numeric String MrBill Excel Worksheet Functions 1 November 2nd 05 05:44 PM


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