Hello, I have 3 Google sheets (Sheet1, Sheet2 and Sheet3) with number values in column A, starting from cell A3. I would like a formula that writes in Sheet4 duplicate values extracted from the first three sheets. I found this formula applied to two sheets:
Formula:
=ArrayFormula(UNIQUE(TRIM(FILTER({A3:A;Sheet2!A3:A};COUNTIF({A3:A;Sheet2!A3:A};{A3:A;Sheet2!A3:A})>1))))
But I would like the same formula applied to three sheets.
Thanks for helping me!
Last edited by parvares; 09-13-2022 at 10:26 AM.
it would be a lot easier to create a solution if you could provide a sample file.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Found the solution:
=ARRAYFORMULA(UNIQUE(TRIM(FILTER({Sheet1!A3:A;Sheet2!A3:A;Sheet3!A3:A};COUNTIF({Sheet1!A3:A;Sheet2!A3:A;Sheet3!A3:A};{Sheet1!A3:A;Sheet2!A3:A;Sheet3!A3:A})>1))))
Last edited by parvares; 09-16-2022 at 09:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
parvares 
Register To Reply
Bookmarks