Thread: [Solved] Use SMALL or LARGE to find date
View Single Post
 
Old 05-02-2011, 01:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi udea,

To use the formula from sheet 2, the syntax sould be:
=LARGE(Sheet1!A1:A9,2)
If you use this formula and the list is empty, you will get:
#NUM!
If you need to supress such errors you need to express the formula like:
=IF(ISERROR(LARGE(Sheet1!A1:A9,2)),"",LARGE(Sheet1 !A1:A9,2))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Last edited by macropod; 05-03-2011 at 01:20 AM.
Reply With Quote