ne an excel formula to insert indicator

[guanqiao]

Hi ,
the attached excel file was sorted by column A then by column B(from newest to oldest). I need an formula on column E.



To make things more simple, here is what I want:
if the same email address repeated 5 times on column A, then only the first one need to put yes on column E

my file is excel 2013 version.

[Mvaldesi]

Like this?

=IF(C2="","Yes","No")

[63falcondude]

Please update your "MS-Off Ver" to whatever you are currently using. Your profile shows Excel 2003 but you uploaded a .xlsx which requires Excel 2007 or newer.

Getting to your question, it's not clear what you are looking for. You want a formula to produce the values in the "Indicator" column (column E)?

If so, I don't see the logic for why they should show as "Yes", "No", or "Duplicated".

[guanqiao]

yes, I need to produce the value in column E. The logic is updated in my post.

[guanqiao]

solution found;

=IF(COUNTIF(A:A,A2)>1,IF(COUNTIF(A$2:A2,A2)=1,"1st","other dups"),"")

[FlameRetired]

Glad you found solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.