Sort items, ignore doubles. | General Excel Questions & Answers

Sort items, ignore doubles.

Dritan Naum

Member

Members

Forum Posts: 18

Member Since:
July 19, 2014

Offline

April 17, 2017 - 4:41 am

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

See Answer

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 703

Member Since:
June 25, 2016

Offline

April 17, 2017 - 11:21 am

Hi Dritani

See if this helps. I have included 2 examples (Advanced Filter and Array Formula)

Sunny

Answers Post

Dritan Naum

Member

Members

Forum Posts: 18

Member Since:
July 19, 2014

Offline

April 17, 2017 - 7:38 pm

Thank you Sunny,

You really provided me with great solution.

You are really a professional in Excel :).

Wishing you all the best,

Dritani

Dritan Naum

Member

Members

Forum Posts: 18

Member Since:
July 19, 2014

Offline

June 11, 2017 - 1:10 am

SunnyKow said
Hi Dritani

See 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

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 703

Member Since:
June 25, 2016

Offline

June 13, 2017 - 9:00 am

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

Dritan Naum

Member

Members

Forum Posts: 18

Member Since:
July 19, 2014

Offline

June 18, 2017 - 5:15 am

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

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 703

Member Since:
June 25, 2016

Offline

June 19, 2017 - 1:36 am

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