| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill sequence...
I am sure this is simple but cannot figire it out. I don't use Excel that much but need to create a large table. I have a list of numbers that I want to sequence as I drag fill handle. This is what I want: 190 83 00*1*x 190 83 00*2*x 190 83 00*3*x, etc. What I get: 19*1 *83 001x 19*2* 83 001x 19*3* 83 001x How do I get it to ascend the last number ratehr than the first? I went thru help but am confused. This is just a plain number, not currency, dates, etc. *Please help! * thanks :) -- tiaj ------------------------------------------------------------------------ tiaj's Profile: http://www.excelforum.com/member.php...o&userid=32792 View this thread: http://www.excelforum.com/showthread...hreadid=526148 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto fill sequence...
Hi
Use something like this: ="190 83 00"&ROW()-1&"x" You may need to use ROW()-2, or -3 to get the correct starting figure. Andy. "tiaj" wrote in message ... I am sure this is simple but cannot figire it out. I don't use Excel that much but need to create a large table. I have a list of numbers that I want to sequence as I drag fill handle. This is what I want: 190 83 00*1*x 190 83 00*2*x 190 83 00*3*x, etc. What I get: 19*1 *83 001x 19*2* 83 001x 19*3* 83 001x How do I get it to ascend the last number ratehr than the first? I went thru help but am confused. This is just a plain number, not currency, dates, etc. *Please help! * thanks :) -- tiaj ------------------------------------------------------------------------ tiaj's Profile: http://www.excelforum.com/member.php...o&userid=32792 View this thread: http://www.excelforum.com/showthread...hreadid=526148 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto fill sequence...
worked like a charm! I knew it was easy :) thank you!! -- tiaj ------------------------------------------------------------------------ tiaj's Profile: http://www.excelforum.com/member.php...o&userid=32792 View this thread: http://www.excelforum.com/showthread...hreadid=526148 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto fill sequence...
Glad to help and thanks for the feedback!
Andy. "tiaj" wrote in message ... worked like a charm! I knew it was easy :) thank you!! -- tiaj ------------------------------------------------------------------------ tiaj's Profile: http://www.excelforum.com/member.php...o&userid=32792 View this thread: http://www.excelforum.com/showthread...hreadid=526148 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill option | New Users to Excel | |||
| Macro for Auto Fill | Excel Discussion (Misc queries) | |||
| Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Hybrid Mode
