Excel formula (preferable) or python script to check for unique numbers in large file-CodePudding

Home > OS > Excel formula (preferable) or python script to check for unique numbers in large file

Excel formula (preferable) or python script to check for unique numbers in large file

Time：08-25

I am trying to check for a unique minimum number in column F - it should not be the same as the rows previous. File has over one thousand rows.

CodePudding user response：

With Office 365:

Put this in F2 and copy down the dataset.

=MIN(FILTER(A2:E2,ISERROR(MATCH(A2:E2,$F$1:F1,0))))