Is there a way I can create a calculuated column in powerpivot with the following formula? When I use it in regular excel it freezes the sheet.
=IF(ISNUMBER(MATCH(A2, $A$1:$A1, 0)), "Dupe", "")
Is there a way I can create a calculuated column in powerpivot with the following formula? When I use it in regular excel it freezes the sheet.
=IF(ISNUMBER(MATCH(A2, $A$1:$A1, 0)), "Dupe", "")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks