Not logged in [
Login
-
Register
]
You Are Not Registered Or Not Logged In
Corsa Sport
»
Message Board
»
Off Day
»
Geek Day
»
Need an Excel expert
» Post Reply
Post Reply
Who Can Post?
All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Tahoma
Times New Roman
Trebuchet MS
Script MT Bold
Stencil
Verdana
Lucida Console
-2
-1
1
2
3
4
5
6
White
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
[quote][i]Originally posted by Balling[/i] A few of you are Excel experts I know, so here's a bit of a challenge if you like. I need a formula that gives the following output: R201A01 R201A02 R201A03 R201A04 R201A05 R201A06 R201B01 R201B02 R201B03 R201B04 R201B05 R201B06 R201C01 R201C02 [snip] R201E05 R201E06 R202A01 R202A02 [snip] R220E05 R220E06 So... Last number counts from 01 to 06. Then letter is increased from A to E. Then first number counts from 201 to 220. Can it be done? [/quote]
Post Options:
Disable smileys?
Turn BBCode off?
Receive email notification of new replies?
This is a long topic, click
here
to review it.