Pull unique values from column without duplicates and export to another sheet

Originally Posted by icestationzbra

=IFERROR(INDEX(Sheet1!$A$1:$A$10,MATCH(0,INDEX(COUNTIF(Sheet2!$A$1:$A1,Sheet1!$A$1:$A$10),0),0)),"-")

I used the above code to build a spreadsheet that de-duplicates any entries. The problem is the above code does not work in 2003 (I have 2010 but the work environment is 2003).


To explain what I'm trying to do: My workbook has two sheets. The input sheet and the output sheet. The input sheet is where the users paste a report generated by an automated system every week. The output sheet picks out picks out the unique rows based on a column that contains id#'s- some of these id#'s are duplicated so the rows contain the same information.

Once I have the unique id#'s populated on the output sheet; I use this code to pull the corresponding information from the adjacent cells in that row:
{=INDEX(Sheet1!G:G,MATCH(Sheet2!E3,Sheet1!E:E,0),1)}

From taken from this thread:
http://www.excelforum.com/excel-form...cific-row.html

tl;dr
I need a code that pulls unique rows (based on cells in a column) from one sheet and pastes it into another sheet. It can't be a macro because the users will be adding additional columns on the second sheet. It also has to work in Excel 2003.