Hello, I need to create a formula that does the following:
Using a single formula I need to detect all of the duplicates in a list, if the term has already appeared in the list the formula should display it on the same row (delete it from it's original location and move it to the same row). If the term has no already appeared then the formula should display N/A. The values in the column are text, if that makes a difference.
I tried using countif but value if true can't be another cell's text.
Thank you in advance for your help