Excel 'IF' problem

[emilyshaw93]

Hi there,

I have an excel problem. I have set up quite a complex workbook over multiple sheets.

I have a list of names from one sheet, as below:

Adam 1
Emily 3
Emily 3
Emily 3
John 2
John 2

Basically, this counts the number of times a name is mentioned in a previous sheet. What I want to happen is that if a name is mentioned AT LEAST once, to move it into another list, but only to move one name (ie only 1 Emily and 1 John), not all references to it.

I have set the system up so that the formula works for just 1 mention, using the formula below:
=IF('NAMES'!I4=1,'NAMES'!B4)

Where I4 refers to the counting function set up, and B4 refers to the corresponding name itself.

So basically, if used AT LEAST once, copy the name across, but ONLY ONCE.

Any help much appreciated!

 

[Peter_SSs]

Duplicate to [url]http://www.mrexcel.com/forum/excel-questions/901485-help-sorting-duplicate-data.html[/URL]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #9 of the Forum Rules.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.