Hi everyone,
Here is my problem:
In the Column A are the Names
With Yellow Colour on the Column B are the Vegetable & Fruits which some of them are doubles
With Orange Colour on the Column B are the unique relation between Vegetable & Fruits and Names
So I want to return the value from Column B to the TABLE 2 but only the unique Vegetable & Fruits who are related with diferrent Names on Column A
and ignor the doubles Colored with Yellow in Column B
Can you help me to build with such a formula including "ctrl+shift+enter"?
I don't want to use PivotTable or query.
I have attached file here.
Thank you,
Dritani
Hi Dritani
See if this helps. I have included 2 examples (Advanced Filter and Array Formula)
Sunny
Thank you Sunny,
You really provided me with great solution.
You are really a professional in Excel :).
Wishing you all the best,
Dritani
SunnyKow said
Hi DritaniSee if this helps. I have included 2 examples (Advanced Filter and Array Formula)
Sunny
Hi Sunny,
I have another question about the excel solution (relating with extracting data).
Attached is the file,
thank you
Dritan
Hi Dritan
See attached.
You will need to delete the error (it is showing when I opened the file) from cell E14 of the Data sheet. It somehow caused the formulas to give inaccurate result.
Hope this helps.
Sunny
Thank you for the answer,
I have see the comment, but I'm not see any error how can I find the error, or how to remove the error?
Thx,
Dritan
Hi Dritan
You may not see it, possibly it could be a custom function that is not available in Excel 2010. That is why it is giving a #NAME? error in cell E14 of the Data sheet.
I have included a screen shot in the attachment as seen by me.
Sunny
