Forum Discussion
Match Function - Checking various sheets
Good day community. I need assistance please. I need to see if Data is dupplicated in various sheets. I currently use a match function ,but I`m 1unable to set the range of the match lookup a...
I thought you can create a matrix where you can count if there are duplicates between cells and sheets
I have tested it, it works. if you have more sheets add their names in the matrix
best of luck
