Hi All,
I want to print the numbers on excel based on the input taken. For example, if have entered the value 10. In excel the value from 1 to 10 to be displayed on the column-like below
1
2
3
4
5
6
7
8
9
10
Hi All,
I want to print the numbers on excel based on the input taken. For example, if have entered the value 10. In excel the value from 1 to 10 to be displayed on the column-like below
1
2
3
4
5
6
7
8
9
10
With your reference number in D2, this in A1 copied down as far as you will ever need:
=IF(ROW()>$D$1,"",ROW())
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Put this code in the Workbook module:
Now whenever you enter a number into Row 1, a sequential list of numbers from 1 to that number will be listed in that column.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
My take on this one...Enter any number into A1
Please Login or Register to view this content.
Last edited by sintek; 07-30-2019 at 11:10 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks