Values of Column to Other Sheet, With out duplicates

**UNNI NAIR** · 10-11-2019, 05:47 AM

Dear Friends, Have a Good Day.

I need a values of a row

to other sheet without

Duplicate.

Attach sample here with

**PaulM100** · 10-11-2019, 05:50 AM

Array formula(Ctrl+Shift+Enter instead of enter to take effect) in F6: =IFERROR(INDEX(Sheet1!$G$3:$G$341, MATCH(0, COUNTIF(F$5:F5,Sheet1!$G$3:$G$341), 0)),"")

Values of Column to Other Sheet, With out duplicates

LinkBack

Thread Tools

Rate This Thread

Display

Values of Column to Other Sheet, With out duplicates

Re: Values of Column to Other Sheet, With out duplicates

Thread Information

Users Browsing this Thread

Similar Threads

Finding duplicates in column A and adding values in column B as the user types

Merge values from column in one cell, based on duplicates in another column

Delete rows where column A has duplicates based on values in Column B

[SOLVED] Find duplicates in column A, add values from column B (possibly delete duplicates)

[SOLVED] Macro to count unique values in a column, enter it in next column, then delete duplicates

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

Script to check for duplicates in one column then alter adjacent column values

Bookmarks

Bookmarks

Posting Permissions