Forum Discussion
extract information
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.
In essence I need a list of all 'Order placed on PO...' in column C - but it will never be the same amount.
The future raw data will be different - is there a way to tackle that?
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.