I need some help, I am using Excel 2021.
How can I replace duplicate values with blank cells while keeping the first instance of the cell as it is? It has some values under the "Clean Data (Extracted)" worksheet and I added the formula to extract the values inside the parentheses.
=LEFT(MID('Original Data'!H2,FIND("(",'Original Data'!H2)+1,LEN('Original Data'!H2)),FIND(")",MID('Original Data'!H2,FIND("(",'Original Data'!H2)+1,LEN('Original Data'!H2)))-1)
Bookmarks