View Single Post
  #4   Report Post  
Chickalett Chickalett is offline
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by
=SMALL((A3,C5,D18,D21), 2)
Thanks,
What if my values are on different sheets, like for instance:
=SMALL((A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)
It doesn't seem to work then.