View Single Post
  #2   Report Post  
Old August 8th 15, 10:27 AM posted to microsoft.public.excel.newusers
Vabs Vabs is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 3
Default Select a value from a list and remove, if any, of another list ...

Hi

use this array formula in C1 & drag down till C5, on change of value in B1 value in range C1 to C5 will change.

=IFERROR(SMALL(IF($A$1:$A$5<$B$1,$A$1:$A$5,""),RO W(A1)),"")

Cheers!!
ExcelVbaLab.com