• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

FILTER formula

yande

New Member
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:
PRODUCTQUANTITYPRICE 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:
63434

Help me please.

Tq in advance.
 
Top