How to use the list with a list in PQ

[citizenbh]

Hi,
I apologize to my English.

I have stood on this issue, please help

#"Added Custom3" = Table.AddColumn(#"Added Custom4", "Replace", each Text.ReplaceRange([Text], List.Min(List.Select([Marker], each _ > [COLOR=#ff0000][B]10[/B][/COLOR])), 0, "Sign"))

Formula works fine with number.

How in the above expression number 10 replaced with list which is located in column [Position], so that the individual takes the value from the list.
(Columns [Position] and [Marker] are the list)

 

[SimonLunn21]

Hi Marcel,

I am trying to split a text column based on a list of positions. I can see you have done this in the solved problem above, but i am not sure how to do it myself.

Are you able to provide some basic explanation for this?

ie i have a column with [Text] and a list with [Positions]

Any help would be appreciated.

Thank you,
Simon
My suggestion is to split the text