Hi,

Is there a way to use the If function to determine if a row in excel is the same from column A to K.

If this is the case, then the row should overwrite the existing row.

If not, then the new row should be an append range.

NB: it is important that the new row replace the old row on the same location, if column A to K is the same.

I hope that someone can help me out with this?