Hi there,

I hope you can help me, so far I have managed to create a formula which searches a range of data (SKU’s) and returns a count of the occurrences of that SKU. The search includes where the SKU forms part of a larger group of SKU’s. E.g. SKU ‘PL009’ is listed as ‘PL009’, ‘PL009 SB420’ and ‘SB010 PL009 SK008’ and therefore my formula returns the value 3 which is what I want. The formula i have used is this: =COUNTIF(Q$2:Q$786,"*"&T2&"*")

I would now like to go one step further and for the SKU’s where the count is more than one I would like the values to be returned in a list linked to the SKU searched for. Should i be using a pivot table? I'm a bit green with excel and please i'd managed to get as far as i have but i'm now stumped!

Any help would be appreciated.

Thanks

Kathryn

Thank you for replying. To clarify

Column T contains the singular list of SKU's i.e. 'PLU009'. There are 664 of these in total. Column Q is a complete list of our SKU's including those in column T (786 in total), it includes the single instance i.e PLU009 and any combination of it. e.g 'PLU009 SB009'.

Having done a simple count of the instances the SKU's (Column U) I now want to have the detail behind that count. E.g where column U shows 3, i want the data behind the count so that i can see in real terms 3 is actually PLU009, ‘PL009 SB420’ and ‘SB010 PL009 SK008’. I hope that makes sense