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.
Bookmarks