ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numerical patterns in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/112019-numerical-patterns-excel.html)

Clueless

Numerical patterns in Excel
 
How do I create a pattern of 50? Example 32001-32050

Gord Dibben

Numerical patterns in Excel
 
Not sure of your needs but maybe............

In A1 enter 32001

Right-click on A1 fill handle and drag to A50

Release and "Fill Series"


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 11:04:02 -0700, Clueless
wrote:

How do I create a pattern of 50? Example 32001-32050



RagDyeR

Numerical patterns in Excel
 
Enter 32001 in the first cell,
And 32050 in the next cell.

Select *both* cells,
And drag down to copy as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Clueless" wrote in message
...
How do I create a pattern of 50? Example 32001-32050



RagDyeR

Numerical patterns in Excel
 
I hit <Send before realizing that you didn't state what you wanted your
third number to be!

What exact pattern are you looking for?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
Enter 32001 in the first cell,
And 32050 in the next cell.

Select *both* cells,
And drag down to copy as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Clueless" wrote in message
...
How do I create a pattern of 50? Example 32001-32050





All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com