Thread: Select a value from a list and remove, if any, of another list ...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Vabs Vabs is offline
external usenet poster
  
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
Reply With QuoteReply With Quote