Hello.
I'm trying to auto populate cells based on given quantity.
For example if I enter 1 in the quantity cell I want one height cell auto populated with a predefined ranged of numbers. If 3 is entered then 3 cells would be auto populated, and so forth.
Is this possible using formulas?
Any help would be super appreciated. Thank you.
Last edited by ragnadok; 02-09-2020 at 07:40 AM.
Welcome to the forum.
Where are your expected results? All I can see are randomly generated numbers.
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.
Hello and thank you for the welcome.
I'm trying to automatically fill height with random numbers based on given quantity but i am currently filling it in manually.
This sheet is just one part and goes on for hundred of different tree types so it can get really repetitive to fill in all the heights.
Thank you.
OK - that's not what I asked. WHERE are you expected results? Cell references, please.
Sorry if my question wasn't thorough enough.
I just want to auto populate columns D to I with random numbers based on entered quantity in column C.
So, if I entered the number 10 in quantity then all six columns in height would be autofilled with a random number because there are only six columns of "height". If I enter 2 in column C I want two columns of "height" to be auto filled with a random number and so on.
Hope you understand my question.
No, sorry, I don't get it at all.
No worries.
I uploaded a simplified sample sheet.
I just want to auto fill the heights with random numbers based on quantity entered.
If 5 entered in quantity then I want 5 cells under height to be automatically populated with random numbers.
Thank you.
No clearer (to me) - sorry. Wait for someone else to have a look.
no problem. thanks anyway!
Try this in B2:
=IF(COLUMNS($B2:B2)<=$A2,RANDBETWEEN(5,6),"")
Thank you so much. That worked perfect.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
You're welcome! Thank you for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks