How To Hide Previously Used Items In Drop down List in Excel | Remove us...

In this video you will learn How to hide used items in drop down list in excel? Or how to remove used item in drop down list?

Formula 1 =IF ( COUNTIF ( $F$1:$F$10,A1 ) >=1,"",ROW ( ) ) Formula 2 =IF ( ROW ( A1 ) -ROW ( A$1 ) +1>COUNT ( B$1:B$11 ) ,"",INDEX ( A:A,SMALL ( B$1:B$11,1+ROW ( A1 ) -ROW ( A$1 ) ) ) ) Formula 3 =OFFSET ( Sheet2!$C$1,0,0,COUNTA ( Sheet2!$C$1:$C$10 ) -COUNTBLANK ( Sheet2!$C$1:$C$10 ) ,1 )