How to add more coding(?)

[krispo]

Hello,

I am not a pro at Excel by any means but I'm trying to fix this one Excel file I have at work and I just don't have the knowledge to know what to put into it.

I'm trying to add more of that [RCCC]. I've tried adding commas after 300100 and it wouldn't do anything. I've tried adding "300100" , "######" and it only gives me an error.

What am I supposed to type so that I can add as many as I want? Please advise.

Thank you.

[v-rzhou-msft · Accepted solution]

Hi @krispo ,

I think you can code as below to check list value.

= Table.SelectRows(#"Replaced Errors",each List.Contains( {"300100","300200"},[RCCC]))

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ghoshabhijeet]

@krispo Thanks for posting your query.

It seems like you are trying to replace values. If yes, just right click on the column and select Replace Values and type the values you want to replace and replace with and it should work.

If no, please share some more details and some sample data to work on. Thanks!

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍