title: Formula or VBA to find and remove row-wise duplicates but keep column-wise duplicates
body: <p>I have an excel sheet with duplicate entries in rows and columns (See sample below).</p>
  <p>I need to eliminate values that appear more than once in each row so that each row is left with only unique values, while keeping the column-wise duplicate values. I have scoured the internet for days but there doesn't seem to be a solution to this anywhere. All I can find are the basic duplicate data elimination techniques which wouldn't work in my case. Any solution will be very much appreciated!</p>
  <p><img src="https://i.stack.imgur.com/lfQvF.png" alt="Sample of what I'm trying to get at" /></p>