Размер видео: 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: ruclips.net/video/uSbsnkfqX1Y/видео.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: ruclips.net/video/uSbsnkfqX1Y/видео.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."