•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I change the array of my filter function using a dropdown list.
Hey, any help would be super appreciated!
Here is what I have.
=TAKE(SORT(FILTER(February!A:H,February!C:C = A3, ""), 8, -1), 5)
I'm trying to set up a dropdown list that changes February to March/April/Whatever I want.
I have tried creating a table with the full values like this:
| Dates | Column1 | Column2 |
|---|---|---|
| January | February!A:H | February!C:C |
| February | February!A:H | February!C:C |
Then using VLOOKUP in the FILTER(array, field, doesn't seem to work.
Does anyone have any suggestions on how I can get this working?
I have to automate this somehow x_x
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#FILTER
#SORT
#TAKE
#VLOOKUP
#dropdown list
#Excel
#filter function
#array
#automation
#function
#table
#data
#values
#C:C
#A:H