Partial text lookup

**Maartenvds89** · 07-13-2012, 04:01 AM

Hello everybody!

For work I have to make some data analysis.
We try to measure which color is most used every week.
However, the data in column A can reach to 10.000 rows.
In column B there are 300 colors available in our stock.
In Column C is would like to see the color code of Column B where it is used in Column A.

color.jpg

**Pepe Le Mokko** · 07-13-2012, 04:05 AM

Perhaps post a sample sheet instead of a picture?

**Maartenvds89** · 07-13-2012, 04:19 AM

Color.xlsx

Here you go..

**Pepe Le Mokko** · 07-13-2012, 04:41 AM

Perhaps

Please Login or Register  to view this content.

and pull down as needed

**Maartenvds89** · 07-13-2012, 04:47 AM

Didn't work. Don't understand why countif would help?

RESULT:
0
0
0
2
0
0
0
4
0
8
0
0
0
0
0
0
0
0

**Pepe Le Mokko** · 07-13-2012, 04:50 AM

Could you post an example of what you want to achieve?

**Maartenvds89** · 07-13-2012, 05:39 AM

No problem.

You see what I where I'm trying to get to?
Please if you have any questions.. Just ask.
I'll try to explain as good as possible.

Color.xlsx