r/excel•
Test_Trick

Power query (column based on multiple contains “x”)

unsolved

Hi all Looking to create a column that produces value = True if…. Any one of 80 columns contains the word “jump”.

Can’t wrap my mind how to do this.

If column 1 contains Jump the True. Similarly if column doesn’t contain jump but column 2 does then also True etc etc.

Posted Oct 12, 2023, 7:33 AM UTC

11

No comments yet

Nobody commented on this post, or the comments weren't captured.