Numerical patterns in Excel
How do I create a pattern of 50? Example 32001-32050
|
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 |
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 |
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