Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge

Reply
 
Thread Tools Display Modes
Old 07-10-2013, 08:35 AM  
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 
Join Date: Aug 2000
Location: Omaha, NE, USA
Casino cash: $5056
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: 404
Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.
  Reply With Quote
Old 07-10-2013, 08:39 AM   #2
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $11788
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: 28,643
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:51 AM   #3
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 

Join Date: Aug 2000
Location: Omaha, NE, USA
Casino cash: $5056
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: 404
Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.
  Reply With Quote
Old 07-10-2013, 08:56 AM   #4
Donger Donger is offline
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675 N 106.475 W
Casino cash: $356
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: 78,176
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, 08:59 AM   #5
Saul Good Saul Good is offline
We Ready
 

Join Date: Jul 2005
Casino cash: $16165
Quote:
Originally Posted by Donger View Post
I learned a new word today. Neat.
You didn't know what "neat" meant? That's odd.
__________________
Quote:
Originally Posted by Prison Bitch View Post
Colon is 0.7 WAR or 5M in value. He makes 500k. Getting pretty close, and since he's producing war each of the next 4 years of club control, he's fair value for Upton straight up. More than fair actually.
Posts: 32,159
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, 09:00 AM   #6
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $11788
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: 28,643
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, 09:02 AM   #7
Donger Donger is offline
"Think BOOM!"
 
Donger's Avatar
 

Join Date: Nov 2003
Location: 33.675 N 106.475 W
Casino cash: $356
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: 78,176
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, 09:10 AM   #8
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 

Join Date: Aug 2000
Location: Omaha, NE, USA
Casino cash: $5056
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: 404
Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.Iron Chef is a favorite in the douche of the year contest.
  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 07:44 AM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.