Hi everyone
Not sure how to do this, but I have a bunch of files with a lot of detail in but I only really need to get the data from the row after the row that contains the text "journal entry" as attached.
I tried a multi-row formula to create generate a value with "TRUE" if there was a match, with the intention of then filling down and applying a filter to only the true values but I couldn;t get it to work - ideally the true value would have been 1 cell down i.e row+1= TRUE but couldn't get that to work either!
Thanks for looking!
Cass
Solved! Go to Solution.
Excellent - that worked nicely! Thanks a lot