| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Supress #Ref! error
The formula below finds the second occurence of a value in a table and reurns
another value and works OK. The problem is that there isn't always a second occurence and it returns a #REF! error whicj looks a mess. Is there any way of supressing the error? =INDEX(Sheet1!$A2:Sheet1!$F50000,SMALL(IF(Sheet1!$ A2:Sheet1!$F50000=$A5,ROW(Sheet1!$A2:Sheet1!$F5000 0)-ROW(Sheet1!$A2)+1,ROW(Sheet1!$F50000)+1),2),2) Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Supress (blank) in pivottable | Excel Discussion (Misc queries) | |||
| how do I supress text in a column? | Setting up and Configuration of Excel | |||
| Supress Scientific Numbers?? | New Users to Excel | |||
| #div/0! how do i supress? | Excel Worksheet Functions | |||
| Supress error message | Excel Discussion (Misc queries) | |||
Threaded Mode
