In the attached sample file, is there a way that I can remove duplicate rows based only on the contents of the cells in column H? No matter what the values are in any of the other columns. If it is in column H more than once? Remove all other instances leaving just the one.
I cannot use absolute references... the data rows vary from day to day.
Please advise and thanks. -R-