I need to do a find like a sumif or vlookup and append the results into a string within MS Excel.
I have data that appears within a table and I have SUMIFS working now on the number element. However, there is a column that has a text reference which I need to harvest from the list for the matches (like a SUMIF) and display them as a result against my result sheet.
So would get
Dan 80 hours (made up of 4 finds in the table) ABC123, Z345, LK8, 98KJ (reference made up of the 4 finds discussed earlier).
Apart from creating a VBA statement to run on each criteria (Dan, Mike, John etc...) and searching and building an array possibly, cannot think of another solution.... And that would take some work from me.
Any ideas please?
Many thanks in advance