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") )
Glad this help & Thanks for providing feedback
Just in case your 2nd row where you wrote "blank" is actually blank/empty:
=LET(
noBlank, FILTER(A:A, A:A<>""),
INDEX(noBlank, SEQUENCE(ROUNDUP((ROWS(noBlank)-1)/2,0),,2,2))
)
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/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'.
The future raw data will be different - is there a way to tackle that?
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") )In essence I need a list of all 'Order placed on PO...' in column C - but it will never be the same amount
Is "Order placed..." a consistent string?
- yes, 'Order placed on PO...' is consistent string.