|
|
|
|
#1
05-02-2011, 01:43 PM
|
||||
|
||||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Small font
|
jpslon1 | Outlook | 1 | 01-10-2011 12:24 AM |
| I think my Word vocabulary is too small... | showgie | Word | 0 | 05-14-2010 03:55 PM |
| Fonts to small | pljames | Outlook | 0 | 10-09-2007 06:19 PM |
| new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
|
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |
Windows 7 32bit 
Office 2000
Hybrid Mode