ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
hey dude, can you make a multiple selection dropdown list as cell reference in query?
So I got into several methods of doing just that in this video. I go into an advanced case at the end to filter multi-select dropdowns in the data as well as from the reference: th-cam.com/video/uSbsnkfqX1Y/w-d-xo.html
for search Name Product, why that formula : "&If(C3="", , " and lower(B) contains ' " &lower(C3) &" ' ") why not and lower ( C) in C Product coloumb
In my understanding, colom B is date
You're looking at the columns in the search tab, but it's actually searching the "DATA" column, and the product is in column B there.
@@SheetsNinja "Yes, I just realized that it's a different sheet, thanks."
hey dude, can you make a multiple selection dropdown list as cell reference in query?
So I got into several methods of doing just that in this video. I go into an advanced case at the end to filter multi-select dropdowns in the data as well as from the reference: th-cam.com/video/uSbsnkfqX1Y/w-d-xo.html
for search Name Product, why that formula : "&If(C3="", , " and lower(B) contains ' " &lower(C3) &" ' ") why not and lower ( C) in C Product coloumb
In my understanding, colom B is date
You're looking at the columns in the search tab, but it's actually searching the "DATA" column, and the product is in column B there.
@@SheetsNinja "Yes, I just realized that it's a different sheet, thanks."