Hi,
I would like a formula which will output:
"cook"plus upto 3 numbers
example: cook10, cook185
thanks
Hi,
I would like a formula which will output:
"cook"plus upto 3 numbers
example: cook10, cook185
thanks
If you enter "cook10" in a cell and pull down it increments automatically
I would the number to increase by 5 or so and not in sequential order.
Increase by 5 is the start of a sequence. If you want the appearance of randomness, enter 2 of them manually:
COOK10
COOK27
Then highlight both and drag down. This looks a little more random unless someone stares at it. We're just trying to give you simple answers to your question since you don't explain how/why the need to randomize your cook numbers are.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks