B bines53 Active Member Mar 31, 2015 #1 Hello everyone, Range has the numbers 1 through 8, I need a formula that find, What are the last two unique numbers, are listed. The desired outcome,3 ,6. Thank you! Attachments test.uni.xlsx test.uni.xlsx 7.7 KB · Views: 1
Hello everyone, Range has the numbers 1 through 8, I need a formula that find, What are the last two unique numbers, are listed. The desired outcome,3 ,6. Thank you!
John Jairo V Well-Known Member Mar 31, 2015 #2 Hi again @bines53. This is an option (In C2 and copy to C3): =INDEX($A$2:$A$32,AGGREGATE(14,6,(ROW($A$2:$A$32)-MIN(ROW($A$2:$A$32))+1)/(FREQUENCY($A$2:$A$32,$A$2:$A$32)>0),3-ROWS(C$2:C2))) Blessings!
Hi again @bines53. This is an option (In C2 and copy to C3): =INDEX($A$2:$A$32,AGGREGATE(14,6,(ROW($A$2:$A$32)-MIN(ROW($A$2:$A$32))+1)/(FREQUENCY($A$2:$A$32,$A$2:$A$32)>0),3-ROWS(C$2:C2))) Blessings!
