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. |
Quote:
Thank you very much, new wrinkle What if the start number is L00002001..The zeros at the front are falling off |
Quote:
|
Quote:
|
Quote:
="L"&TEXT(A1,"00000000") Change the number of zeroes in parenthesis to however many digits you need shown. |
Quote:
|
Quote:
|
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 |
Quote:
|
Quote:
|
Quote:
|
Quote:
|
Quote:
(I'm gonna be a little creeped out if your answer is yes.) |
Quote:
Yup. Marty F. |
Quote:
|
Quote:
He and I worked together for a few months on some projects before he went to work for big "G". |
All times are GMT -6. The time now is 02:16 AM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.