Hello there,
I am new to this forum, but I'll try to be as descriptive as I can.
I am wondering if there's a way to create a list using a number as my range. For example, if I have a number in cell C3, and that number is 25, is there a way to use that to make a list down column A starting in cell A3 with 1 and ending with 25?
The list length would depend on whatever number is placed in cell C3.
I hope you guys can help.
Thank you so much in advance!
In A3 cell
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you so much! That helped a lot!
Would you be kind enough to explain the logic behind that formula?
For future reference.
I would really appreciate it.
Thanks again, I really do appreciate your help.
Glad it helps you and thanks for the feedback.
Regret for the delay in giving reply since I gone for lunch
=ROW() will get the current row number
So when we use =ROW() in A3 cell it will show 3 as result.
but according to you the value should start from 1 in A3 cell so using ROW()-2 will result 1 in A3 cell.
If we drag the formula down then 2 will be getting subtracted from each row result and which will increment the value continuously for every cells.
But the increment should get stopped based on the C3 cell value, so we are adding a check point to show the result when (ROW()-2) is less than or equal to the value of $C$3 with this condition ROW()-2<=$C$3.
If it is less than or equal to C3 then it will show the result arrived by this formula =IF(ROW()-2<=$C$3,ROW()-2,"")
Else it will show nothing =IF(ROW()-2<=$C$3,ROW()-2,"")
I understand now.
I recently took a brief computer programming seminar so this sounds familiar. However, I had no idea excel was capable of all of this.
It's awesome.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks