Forum Discussion
Solved
extract information
Hello Please could you help me extracting information from a column. Normally I would use filter but Im trying to make an automated spreasheet (so that I only paste the data to column A and t...
In essence I need a list of all 'Order placed on PO...' in column C - but it will never be the same amount/value. One day there might be 3 lines, another 30 lines with all different PO numbers at the end. But the beginning phrase will always be 'Order placed on PO'.
OK, so the following should do it:
=LET( noBlank, FILTER(A:A, A:A<>""), FILTER(noBlank, LEFT(noBlank,15)="order placed on") )
OK but now if I add another 'Order placed on PO4' onto cell A8 it will still only show the 3 results
I worked under the assumption - given what you posted - that there's always "something" between each PO row. So, if in A8 you have "blabla" and "Order placed on PO4" in A9 you should get what you want
Sorry the example was simplified - it will never be the same 'something' in between.
Potentially 100 non-important lines, then 'Order placed on PO123456', then another 100 lines of something , followed by 'Order placed on PO654321'.
So I only would need those two 'Order placed on PO...' lines on my list.
Potentially 100 non-important lines, then 'Order placed on PO123456', then another 100 lines of something , followed by 'Order placed on PO654321'.
So I only would need those two 'Order placed on PO...' lines on my list.