Hello, I have 2 Google sheets (Sheet1 and Sheet2), link here. They both have numbers in column A, starting from cell A3. I would like a formula that finds duplicate values in entire columns of both sheets. I found this formula googling, but doesn't seem working:
Thanks for helping me!
Excel Formula:
=(COUNTIF(A:A;A:A)>1)+(REGEXMATCH(A3;TEXTJOIN("|";1;UNIQUE({INDIRECT("Sheet2!A:A"))})))
Thanks for helping me!