Hey! Your video was very helpful. I have a question, how would you go about doing that but instead, using numbers so the criteria being if pop.density is greater than 50, show me the corresponding cells. etc. or if GDP is > 10000. I would greatly appreciate it Essentially, what I want to do is filter using a number, I currently have this code, but it is not working for me. .AutoFilter field:=15, Criteria1:=Range(">C2").Value So C2 is where I have the value, which is 5; I want to filter field 15 to only show me the rows where field 15 is greater than 5. Thank you for your time in advance; I greatly appreciate it.
What if I want to filter for two or more values in the same column?
Thank you so much.
No problem!
Hi Greg! Great content! How would you script dates? I think dates are a little different as they are not text?
Hi gregg is there a way to filter a database with a multiple selection Dropdown as a Filter field? Thanks for the good viedeos.
Hey! Your video was very helpful. I have a question, how would you go about doing that but instead, using numbers so the criteria being if pop.density is greater than 50, show me the corresponding cells. etc. or if GDP is > 10000. I would greatly appreciate it
Essentially, what I want to do is filter using a number, I currently have this code, but it is not working for me.
.AutoFilter field:=15, Criteria1:=Range(">C2").Value
So C2 is where I have the value, which is 5; I want to filter field 15 to only show me the rows where field 15 is greater than 5. Thank you for your time in advance; I greatly appreciate it.
cant download the sample data set in the description. good lesson though! thanks!
Autofilter is so helpful.
Absolutely!