Ashkan from Iran writes:
How can I create non-repeated numbers between 100 and 300 in Excel?
Hi, Ashkan. Thanks for the great question.
What you’re talking about here is creating a “unique series” – and there’s actually a pretty easy way to do it. You didn’t specify any parameters in your query, so I’m guessing that you’re just talking about a series by ones (100, 101, 102…298, 299, 300) right? So what you do is enter the numeral 100 at cell 1A. Then, in cell 2A enter “=a1+1″ without the quotes. This will give you the numeral 101 in cell A2.
To read the rest of this article, you must be a Premium Member.
- Exclusive members-only content, including tips and special reports.
- Always get the lowest price in the WS Store, with an average of up to 15% off every item.*
- The option to select an ad-free Tech Tips newsletter, sent directly to your email every weekday.
- ...and so much more! Don't miss a thing and get your Premium Membership today!