Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room

Reply
 
Thread Tools Display Modes
Old 07-10-2013, 07:35 AM   Topic Starter
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 
Join Date: Aug 2000
Location: Georgia
Casino cash: $7674981
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
Iron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking about
    Reply With Quote
Old 07-10-2013, 07:39 AM   #2
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2336899
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,593
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
    Reply With Quote
Old 07-10-2013, 07:51 AM   #3
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 

Join Date: Aug 2000
Location: Georgia
Casino cash: $7674981
Quote:
Originally Posted by DaFace View Post
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
Posts: 418
Iron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking about
    Reply With Quote
Old 07-10-2013, 08:00 AM   #4
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2336899
Quote:
Originally Posted by Iron Chef View Post
Thank you very much,

new wrinkle What if the start number is L00002001..The zeros at the front are falling off
Slight change in column B.

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

Change the number of zeroes in parenthesis to however many digits you need shown.
Posts: 51,593
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
    Reply With Quote
Old 07-10-2013, 08:10 AM   #5
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 

Join Date: Aug 2000
Location: Georgia
Casino cash: $7674981
Quote:
Originally Posted by DaFace View Post
Slight change in column B.

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

Change the number of zeroes in parenthesis to however many digits you need shown.
Thank you very much...Worked like a charm.
Posts: 418
Iron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking aboutIron Chef is the dumbass Milkman is always talking about
    Reply With Quote
Old 07-10-2013, 07:56 AM   #6
Donger Donger is online now
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $10649900
VARSITY
Quote:
Originally Posted by DaFace View Post
concatenate
I learned a new word today. Neat.
__________________
I think the young people enjoy it when I "get down," verbally, don't you?
Posts: 180,170
Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.
    Reply With Quote
Old 07-10-2013, 07:59 AM   #7
Saul Good Saul Good is offline
Quit your bullshit
 

Join Date: Jul 2005
Location: Bored of winning
Casino cash: $10052799
Quote:
Originally Posted by Donger View Post
I learned a new word today. Neat.
You didn't know what "neat" meant? That's odd.
__________________
Today is not a good day to be a pussy.
Posts: 41,870
Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.Saul Good is obviously part of the inner Circle.
    Reply With Quote
Old 07-10-2013, 08:02 AM   #8
Donger Donger is online now
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $10649900
VARSITY
Quote:
Originally Posted by Saul Good View Post
You didn't know what "neat" meant? That's odd.
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,170
Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.Donger is obviously part of the inner Circle.
    Reply With Quote
Old 05-26-2017, 11:20 AM   #9
Chief Pagan Chief Pagan is offline
Sometimes it's black and white
 
Chief Pagan's Avatar
 

Join Date: Nov 2004
Location: California
Casino cash: $4064900
Quote:
Originally Posted by Donger View Post
I learned a new word today. Neat.
Posts: 6,040
Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Chief Pagan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
    Reply With Quote
Old 05-26-2017, 11:26 AM   #10
Fire Me Boy! Fire Me Boy! is offline
Cast Iron Jedi
 
Fire Me Boy!'s Avatar
 

Join Date: Nov 2004
Casino cash: $9999900
VARSITY
Quote:
Originally Posted by Donger View Post
I learned a new word today. Neat.
Honestly thought concatenate was a typo. Thanks, Google!
Posts: 35,253
Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.Fire Me Boy! is obviously part of the inner Circle.
    Reply With Quote
Old 05-26-2017, 10:51 AM   #11
scho63 scho63 is offline
Politically Incorrect
 
scho63's Avatar
 

Join Date: Feb 2009
Location: Scottsdale, AZ
Casino cash: $3081110
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~


2018 2019 2020 20212022 2023 2024 Adopt a Chief - Clark Hunt and Brett Veach
"The men who drafted Patrick Mahomes"


Posts: 50,128
scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.scho63 is obviously part of the inner Circle.
    Reply With Quote
Old 05-26-2017, 11:03 AM   #12
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2336899
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,593
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
    Reply With Quote
Old 05-26-2017, 11:06 AM   #13
Dayze Dayze is offline
Resident Glue Sniffer
 
Dayze's Avatar
 

Join Date: Nov 2003
Casino cash: $5439358
=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,353
Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.
    Reply With Quote
Old 05-26-2017, 11:06 AM   #14
Dayze Dayze is offline
Resident Glue Sniffer
 
Dayze's Avatar
 

Join Date: Nov 2003
Casino cash: $5439358
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,353
Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.Dayze is obviously part of the inner Circle.
    Reply With Quote
Old 05-26-2017, 11:12 AM   #15
Grim Grim is offline
Starter
 

Join Date: Aug 2012
Casino cash: $-160000
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: 715
Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.Grim must have mowed badgirl's lawn.
    Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump




All times are GMT -6. The time now is 03:39 PM.


This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.