|
07-10-2013, 07:39 AM | #2 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1646899
|
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,984
|
07-10-2013, 07:51 AM | #3 | |
Starter
Join Date: Aug 2000
Location: Georgia
Casino cash: $7614981
|
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, 07:56 AM | #4 |
"Think BOOM!"
Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $9989900
VARSITY
|
__________________
I think the young people enjoy it when I "get down," verbally, don't you? |
Posts: 181,745
|
07-10-2013, 07:59 AM | #5 |
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:00 AM | #6 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1646899
|
|
Posts: 51,984
|
07-10-2013, 08:02 AM | #7 |
"Think BOOM!"
Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $9989900
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: 181,745
|
07-10-2013, 08:10 AM | #8 |
Starter
Join Date: Aug 2000
Location: Georgia
Casino cash: $7614981
|
|
Posts: 418
|
05-26-2017, 10:51 AM | #9 |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
Casino cash: $2391110
|
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,851
|
05-26-2017, 11:03 AM | #10 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1646899
|
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,984
|
05-26-2017, 11:06 AM | #11 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $4849358
|
=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,377
|
05-26-2017, 11:06 AM | #12 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $4849358
|
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,377
|
05-26-2017, 11:12 AM | #13 |
Starter
Join Date: Aug 2012
Casino cash: $-540000
|
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
|
05-26-2017, 11:15 AM | #14 |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
Casino cash: $2391110
|
POS REP SENT TO BOTH OF YOU FOR YOUR HELP THAT WORKED!
Thanks
__________________
"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,851
|
05-26-2017, 11:19 AM | #15 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $4849358
|
agree; I use excel for everything.
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial. RIP & Godspeed: Saccoppo Lonewolf Ed Fire Me Boy |
Posts: 37,377
|
Thread Tools | |
Display Modes | |
|
|