lbrockmeier
New Member
- Joined
- Dec 18, 2017
- Messages
- 7
Hi there,
Would really appreciate any help with this!
I have 2 sheets: Combined Data and VGBB Summary. The snapshot below is VGBB summary. What I need to do is bring over all of the prices associated with each category (e.g. Accessories) to the right of the category. My issue is that there are multiple duplicates of prices for each category. I would like for prices to populate to the right of the category with no duplicates!
<tbody>
</tbody>
Here is the formula I am currently using:
=IFERROR(INDEX('Combined Data'!$A$6:$Q$11959,SMALL(IF('Combined Data'!$Q$7:$Q$11959='VGBB Summary (2)'!$A2,ROW('Combined Data'!$Q$7:$Q$11959)),ROW(1:1))-1,13),"")
Any help is greatly appreciated
Would really appreciate any help with this!
I have 2 sheets: Combined Data and VGBB Summary. The snapshot below is VGBB summary. What I need to do is bring over all of the prices associated with each category (e.g. Accessories) to the right of the category. My issue is that there are multiple duplicates of prices for each category. I would like for prices to populate to the right of the category with no duplicates!
Category | ||||
Accessories | 7.99 | 7.99 | 7.99 | 7.99 |
Pants | 19.99 | |||
Shirts | 14.99 |
<tbody>
</tbody>
Here is the formula I am currently using:
=IFERROR(INDEX('Combined Data'!$A$6:$Q$11959,SMALL(IF('Combined Data'!$Q$7:$Q$11959='VGBB Summary (2)'!$A2,ROW('Combined Data'!$Q$7:$Q$11959)),ROW(1:1))-1,13),"")
Any help is greatly appreciated