|
|
07-10-2013, 07:35 AM | Topic Starter |
Starter
Join Date: Aug 2000
Location: Georgia
Casino cash: $7644981
|
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 |
Posts: 418
|
07-10-2013, 07:39 AM | #2 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2026899
|
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. |
Posts: 51,772
|
07-10-2013, 07:51 AM | #3 | |
Starter
Join Date: Aug 2000
Location: Georgia
Casino cash: $7644981
|
Quote:
Thank you very much, new wrinkle What if the start number is L00002001..The zeros at the front are falling off |
|
Posts: 418
|
07-10-2013, 08:00 AM | #4 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2026899
|
|
Posts: 51,772
|
07-10-2013, 08:10 AM | #5 |
Starter
Join Date: Aug 2000
Location: Georgia
Casino cash: $7644981
|
|
Posts: 418
|
07-10-2013, 07:56 AM | #6 |
"Think BOOM!"
Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $10349900
VARSITY
|
__________________
I think the young people enjoy it when I "get down," verbally, don't you? |
Posts: 180,704
|
07-10-2013, 07:59 AM | #7 |
Quit your bullshit
Join Date: Jul 2005
Location: Bored of winning
Casino cash: $10052799
|
You didn't know what "neat" meant? That's odd.
__________________
Today is not a good day to be a pussy. |
Posts: 41,870
|
07-10-2013, 08:02 AM | #8 |
"Think BOOM!"
Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $10349900
VARSITY
|
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.
__________________
I think the young people enjoy it when I "get down," verbally, don't you? |
Posts: 180,704
|
05-26-2017, 11:20 AM | #9 |
Sometimes it's black and white
Join Date: Nov 2004
Location: California
Casino cash: $3754900
|
|
Posts: 6,163
|
05-26-2017, 11:26 AM | #10 |
Cast Iron Jedi
Join Date: Nov 2004
Casino cash: $9999900
VARSITY
|
|
Posts: 35,253
|
05-26-2017, 10:51 AM | #11 |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
Casino cash: $2771110
|
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.
__________________
"The only difference between sex for free and sex for money is that sex for free costs you a WHOLE LOT more!" ~Redd Foxx~ "The men who drafted Patrick Mahomes" |
Posts: 50,509
|
05-26-2017, 11:03 AM | #12 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2026899
|
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) |
Posts: 51,772
|
05-26-2017, 11:06 AM | #13 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $5179358
|
=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?
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial. RIP & Godspeed: Saccoppo Lonewolf Ed Fire Me Boy |
Posts: 37,361
|
05-26-2017, 11:06 AM | #14 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $5179358
|
Nevermind....DaFace covered it.
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial. RIP & Godspeed: Saccoppo Lonewolf Ed Fire Me Boy |
Posts: 37,361
|
05-26-2017, 11:12 AM | #15 |
Starter
Join Date: Aug 2012
Casino cash: $-300000
|
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. |
Posts: 716
|
|
|