خرید بک لینک

I have an Excel sheet with data formatted as below

  A        B
1 KEY      VALUE
2 Apple    Golden
3 Orange   Navel
4 Banana   Yellow
5 Apple    Gray Smith
6 Orange   Blood

What I want to do is take the unique keys, but print their corresponding values horizontally next to them. I already have a sheet that looks like this:

  A        B
1 KEY      VALUE
2 Apple    Golden
3 Orange   Navel
4 Banana   Yellow

But what I would like is this:

  A        B        C
1 KEY      VALUE1   VALUE2
2 Apple    Golden   Gray Smith
3 Orange   Navel    Blood
4 Banana   Yellow

My formula right now is {=INDEX('$B$2:$B$6,MATCH(<unique key>,$A$2:$A$6,0))} where "unique key" is the cell reference in the second sheet. This formula successfully prints the first value for each key, but I would like for the other matches to populate down the row. Is that possible?

- - , .

برچسب: نویسنده: استخدام کار تاريخ: جمعه 14 اسفند 1394 ساعت: 7:27

صفحه بندی