Hello all,
I have a spread sheet, see below.
<TBODY>
</TBODY>
What I’m looking for is a formula/ vba code that will scan through the name column and extract all the details in which for example Barry has been a participant. And the appropriate details in column b/c. </SPAN>
I was thinking and index and match, but I can’t get it to grab the specific details as it just sees it all as one word. Ideally a VBA code would be better as it runs over various row lengths.
Thanks in advance... </SPAN>
I have a spread sheet, see below.
Name</SPAN></SPAN> | Sales</SPAN></SPAN> | Total sales</SPAN></SPAN> |
DAVE|BARRY</SPAN></SPAN> | 24</SPAN></SPAN> | 1</SPAN></SPAN> |
BARRY|JOHN</SPAN></SPAN> | 47</SPAN></SPAN> | 2</SPAN></SPAN> |
DAVE|JOHN</SPAN></SPAN> | 205</SPAN></SPAN> | 5</SPAN></SPAN> |
<TBODY>
</TBODY>
What I’m looking for is a formula/ vba code that will scan through the name column and extract all the details in which for example Barry has been a participant. And the appropriate details in column b/c. </SPAN>
I was thinking and index and match, but I can’t get it to grab the specific details as it just sees it all as one word. Ideally a VBA code would be better as it runs over various row lengths.
Thanks in advance... </SPAN>