Ok, I have probably an easy one here that people a whole lot smarter than me can whip out an answer quicker than I can.
I have attached a sample of my spreadsheet
I basically want to use a formula to search for each occurance of a specific text string and return the numerical and date values of the the adjacent cells in the same row as it found the text string. I want it to extract all these occurances into a smaller table on the same sheet. I hope the attached spreadsheet shows adequately what I want to do. I dont want to use pivot tables or data filtering to do this.
Thanks
Rob
Bookmarks