I'm trying to create a formula to check to see if a row of 4 cells with numbers in each cell is every duplicated. and then either highlight it or show the row number to where the duplicate is
example:
row a 1,2,3,4
row b 2,3,4,5
row c 3,4,5,6
row d 1,2,3,4
in this example row d would be the duplicate
i'm was trying to use vlookup without any success
would anyone here be able to help with this type of formula??
thanks in advance
Jeff
example:
row a 1,2,3,4
row b 2,3,4,5
row c 3,4,5,6
row d 1,2,3,4
in this example row d would be the duplicate
i'm was trying to use vlookup without any success
would anyone here be able to help with this type of formula??
thanks in advance
Jeff