Hi, with office365 released new formula functions such as "FILTER" and "UNIQUE", I'd like to combine the two formulas to create something that would mimic the "Remove Duplicates" function.
See Attach data set,
if I were to use the "Remove Duplicates" Function based on "employee number" it would keep the first row and remove duplicate rows afterward.
Can UNIQUE/FILTER formula do the samething?
Bookmarks