1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Remove Duplicated and Originals?

So I've got a spreadsheet where I wasnt to see if columns E to V match any other rows, and if they do, remove the duplicates and the originals. Essentially the remove duplicates button but with originals removed too. Or if there's a way to have conditional formatting that it only does it if each value in the row is the same as another row. Does anyone know how? Thanks

(Note: Each column is always Yes or No)

submitted by /u/mujie123
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com