Hello,
How can I generate Sequential intervals from a whole number. (if possible)
For instance:
I have 5 in B1
I would like C1 to show 1,2,3,4,5 or 1 - 5.
Thank you.
Hello,
How can I generate Sequential intervals from a whole number. (if possible)
For instance:
I have 5 in B1
I would like C1 to show 1,2,3,4,5 or 1 - 5.
Thank you.
You could insertin cell C1. This give you "1 - 5" (for instance).Formula:Please Login or Register to view this content.
To have 1, 2, 3, 4, 5 (for instance) in cell C1 some coding needs to be done I think.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks