LinkBack URL
About LinkBacks
Hi Guys,
Is it possible to make a list so that if I had the number 5 the list would give me the numbers 0,1,2,3,4,5. But if i changed the 5 to a 3 for example the list results would change to 0,1,2,3 and so on?
Hi Guys,
Is it possible to make a list so that if I had the number 5 the list would give me the numbers 0,1,2,3,4,5. But if i changed the 5 to a 3 for example the list results would change to 0,1,2,3 and so on?
Give you the numbers where? In one cell? In a range of cells?
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi, So if 5 was in A1, A2 would have a list of 0,1,2,3,4,5
This proposal employs two helper columns (modeled in L:M) which may be moved and or hidden for aesthetic purposes.
The first helper column is populated using: =IF(ROW()=2,0,IF(L1<A$1,SUM(L1,1),""))
The second helper column is populated using: =IF(ROW()=2,0,IF(L2="",M1,M1&", "&L2))
Cell A2 is populated using: =M12
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks