Forum Discussion
AUTO POPULATING CELLS USING A DROP DOWN LIST
It's an intriguing problem, and very solvable. You sound like you're very competent, so I'm just going to point you in a different direction and challenge you to resolve it.
Here's my advice: stop thinking of backing up the list (the list that names the months) three months. Start thinking just of numbers, specifically numbers 1 through 12. And then investigate the MOD function.
You'll find that If you enter any number 1 through 12 in cell A1, this function will yield the number of the month 3 months prior.
=MOD(A1-3,12)
From that, it should be child's play to convert that starting number to the numbers (and then the names) of the three prior months.
- Thank you so much for calling me competent. In all honest though, a week ago, all I knew how to do was =SUM haha. I just dove deep into research and figuring things out(Thank God for YouTube and the internet) I don't know anything about the MOD function, but just like with the INDEX and MATCH functions, I will do my research and figure it out. Thank you for the help.
As variant
in A8 it could be
=UPPER(TEXT(DATE(Sheet1!$H$1,MONTH(1&Sheet1!$S$1)+8+ROW()-ROW($A$7),1),"mmm"))and drag it down to next two cells
- Hey Joseph_Longoria, psst.. the solution to the quiz is in my 1st reply just in case but like mathetes I would also be happy if you would work it out yourself..
BTW, Mr. mathetes user name is also very intriguing.. it sounds like "math it is".. and probably that's why a nice way of throwing up a math challenge 🙂BTW, Mr. @mathetes user name is also very intriguing.. it sounds like "math it is".. and probably that's why a nice way of throwing up a math challenge
Mathetes is actually a Greek word that means learner or student. I like to employ it as my user name on sites like this, where I find I learn a lot over time. And you touched on something: a quick Google search tells me that there is a connection with math as well; I hadn't known that.
