Deleting Rows

[CARBOB]

My worksheet has 376,992 rows of 5 columns, with digits that range from 0-9. I want to delete all the rows that have multiple counts of each digit. Is this enough info?? Can a formula do this?

 

[Joe4]

Do you mean if a single numbers appears more than once within a particular row?

If so, here is a rather crude method, but it should work.
Assuming column A-E and your data begins in row 1, enter this formula on row 1 and copy down for all rows:

=IF(COUNTIF(A1:E1,A1)>1,1,0)+IF(COUNTIF(A1:E1,B1)>1,1,0)+IF(COUNTIF(A1:E1,C1)>1,1,0)+IF(COUNTIF(A1:E1,D1)>1,1,0)+IF(COUNTIF(A1:E1,E1)>1,1,0)

Any row where this formula returns 0 does not have any duplicates. All others do. So you can sort/delete all rows that do not equal zero.

 

[CARBOB]

Works fine, thank you!!