FILTER formula

[yande]

Hi Master,

I found the link that show how to create a drop down list with search option.
But the formula FILTER not exist in my excel. Is there any other way able to replace the FILTER formula?
This is the link for your reference. https://www.xelplus.com/searchable-drop-down-list/

Tq in advance.

 

[deciog]

yande

Here's an example I use for Excel 2010 version or smaller

Decio

 

[yande]

yande

Here's an example I use for Excel 2010 version or smaller

Decio

Thank you so much master!! It works!

 

[yande]

yande

Here's an example I use for Excel 2010 version or smaller

Decio

Hi Master,

I'm facing some issue. My table was like this:

PRODUCT	QUANTITY	PRICE PER UNIT
PATI MINYAK ZAITUN	500​	301.20
OLIVIE	500​	805.20
OLIVIE MINI	500​	400.80
OPU	500​	1,326.60
ULTRA POP	500​	893.40

'PRODUCT' is the place i want to put search option. And in the formula only can use one cell only as Funcionário.
Please help me if there is a solution for this.

My plan was just want to put the formula at the side in the same table, but me facing an issue of duplication item in list like this:


Help me please.

Tq in advance.

 

[deciog]

yande

Check if this is how you want it

Thanks for the feedback, I'm glad I helped

Hugs

Decio