Excel Help
 

I have an Excel question. I need to run consecutive numbering starting at L001001. The hard part is I need the sheet to show 4 sets of each number. 2500 sets 10,000 total entries
L1001001
L1001001
L1001001
L1001001
L1001002
L1001002
L1001002
L1001002...etc

Is there a formula that will accomplish this?

Thanks

If you're able to use a separate column for the numbers, then concatenate, it'll be easy.

Column A:
1001001
1001001
1001001
1001001
=A1+1
=A2+1
=A3+1
=A4+1
(fill down)

Column B:
="L"&A1
="L"&A2
(fill down)

If you're just trying to get them in there and don't need to keep the formulas, you can then copy and paste values from Column B wherever you need them, then delete.

Thank you very much,

new wrinkle What if the start number is L00002001..The zeros at the front are falling off

I learned a new word today. Neat.

You didn't know what "neat" meant? That's odd.

Slight change in column B.

="L"&TEXT(A1,"00000000")

Change the number of zeroes in parenthesis to however many digits you need shown.

No, I knew what neat means. You should have realized that I didn't mean neat, since I did not use a colon and neat was capitalized.

Thank you very much...Worked like a charm.

I need to do two things in the same spreadsheet:

1. A running total in a SINGLE cell at the top of my spreadsheet as I add more and more numbers in a column for each day that passes

2. Underneath that cell that holds the SUM running total I want to have the AVERAGE of those running numbers so that as I add more numbers. it knows to have the AVERAGE add a new day to correctly calculate the total number of days as they increase.

Any help greatly appreciated and POS REP will be sent if it works!

I'm calculating daily money raised.

That should be pretty easy - you just need to make sure the range of your two formulas includes all of the cells where you MIGHT eventually have data. Sum and average formulas ignore blank cells, so that won't hurt anything. So if you're putting your values in column B, your running total formula would be something like:

=SUM(B1:B500) or even just =SUM(B:B)

And your average formula would be:

=AVERAGE(B1:B500) or even just =AVERAGE(B:B)

=AVERAGE(A1:A50000)

can you just insert an average Function in there; where the range is where the data you want averaged begins, then just make it go to like 10,000 to end? that way as you add stuff, whatever you've added each day etc, is captured by that range?

Nevermind....DaFace covered it.

Excel is the most underrated tool the Microsoft ever came out with, IMO.
So powerful.

I know a guy who uses excel scripts to run his firework displays.

POS REP SENT TO BOTH OF YOU FOR YOUR HELP THAT WORKED!

Thanks

agree; I use excel for everything.