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

Originally Posted by icestationzbra

Please Login or Register  to view this content.

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.

vandetta,

Welcome to the forum!
Assuming Sheet2 is the output sheet, put this regular formula (this is not an array formula and thus does not require it be array-entered) in cell E3 of Sheet2 and copy down:

Please Login or Register  to view this content.

Same principle still applies:

Please Login or Register  to view this content.