LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 105
Default Autofill Question

Hi everyone,

I am having alot of difficulties trying to solve this problem.

Basically I am coding something in column A like this;

1. 11XXX (X being any number from 0 to 9 i.e.11001 till 11999)

2. X11XX (X being any number from 0 to 9 ) = this part I have a
problem. How do I fill in every possible combination that has 1 in 2nd
and 3rd spot? e.g. 311411, 211423 .. etc etc

Please help (T_T)


thank you for your help in advance

regards,


James
 
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
column autofill question JohnBee Excel Worksheet Functions 2 December 22nd 07 10:51 PM
Autofill script question Gor_yee Excel Discussion (Misc queries) 2 August 4th 07 07:29 PM
Question about Autofill with a formula Corben Excel Discussion (Misc queries) 14 April 16th 06 11:24 AM
autofill question Ben H Excel Discussion (Misc queries) 0 March 2nd 05 03:37 PM
Autofill question lob Excel Worksheet Functions 2 February 17th 05 04:07 PM


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