auto fill sequence...

  • Thread starter Thread starter tiaj
  • Start date Start date
T

tiaj

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 :)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Range REPOST 6
match formula needed 2
Return Consecutive Values - Pairs 6
Writing a macro to compare columns and return a value 1
Tough problem adding cells from different sheets, in random order 4
countif on cells with formula's won't work correctly 21
Need help with formula to count the number of times each date appe 3
assign a number to the same date & start over with 1 on new date 3

Back
Top