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

Reply
 
Thread Tools Display Modes
Old 07-10-2013, 07:35 AM  
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 
Join Date: Aug 2000
Location: Omaha, NE, USA
Casino cash: $35116
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, 07:39 AM   #2
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $651941
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: 27,149
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: Omaha, NE, USA
Casino cash: $35116
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, 07: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: $1177
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: 74,210
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   #5
Saul Good Saul Good is offline
MVP
 

Join Date: Jul 2005
Casino cash: $184000
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 J Diddy View Post
Saul 2014
Posts: 30,539
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:00 AM   #6
DaFace DaFace is offline
Version 3.0
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $651941
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: 27,149
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: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: $1177
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: 74,210
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:10 AM   #8
Iron Chef Iron Chef is offline
Starter
 
Iron Chef's Avatar
 

Join Date: Aug 2000
Location: Omaha, NE, USA
Casino cash: $35116
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 03:23 AM.


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.