I Included a Google Sheets link
I’m attempting to take apart an unorganized list in a single column, separating it by keywords into columns and rows so that the data can be usable – to maybe make a graph or analyze trends. The trouble I’m having, in general, is the keyword I’m searching for may not be on the exact line I expect it to be, but only one cell either up or down. Is it possible If a match isn’t detected in A2 in would also check A3?
So far I can only get it to search a single cell, but not a range of cells, like A2:A3 and extracts on row 2 inthe appropriate column
Much appreciated if anyone can point me in the right direction