| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
You're welcome :-)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Michael Rekas" wrote in message ... Thanks Ken I like it! Regards Michael On Sat, 29 Jan 2005 15:14:22 -0000, "Ken Wright" wrote: =SMALL(IF(A1:A100,A1:A100),2) array entered using CTRL+SHIFT+ENTER will ignore 0s and blanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| ClearContents method on a passed range | New Users to Excel | |||
| Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| range names | Excel Worksheet Functions | |||
Threaded Mode
