@pixiequeen12, then try this:
Let’s say that you have, oh, 10 columns of data that might be duplicated, and you want to check all 10 columns. So you want to check columns A:J for duplication across all 10 at once. This isn’t so difficult.
Use the CONCATENATE() function to group all of the values from A1:J1 into a single cell:
=CONCATENATE( A1, B1, C1, D1, E1, F1, G1, H1, I1, J1)
and copy that formula down through all the rows of your data. (It’s just possible that this formula will create duplicates that aren’t really dups. Don’t worry about that for now. For example: “Joe Blow 1 10” and “JoeBlow 110” will both concatenate to “JoeBlow110”, making an apparent duplicate. We’ll address that later.)
Sort on this column of concatenated values and apply the formula above from @Michael to flag the “apparent” dups.
If you have thousands of rows of data to review, then I can offer more suggestions to automate the rest of the process as well, but if all you have is a few hundred rows, then this will help you to find those rows that are duplicated completely (and maybe some that “should be” duplicates, but aren’t).
For example, after you sort on the concatenated values, then you can apply @Michael‘s formula to the concatenated values, as explained, AND to some of the other ‘main’ values, as well. The flags that show up in both places would be the ones to concentrate on.