| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Small to return 2nd smallest value
I need to extend the formula to exclude multiple values, empty cells & zero
values in the range. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Small to return 2nd smallest value
Which formula is this?
Pete On Feb 12, 1:34*pm, Rachel7 wrote: I need to extend the formula to exclude multiple values, empty cells & zero values in the range. *Can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Small to return 2nd smallest value
Hi Pete,
It's 'SMALL', Bernard (on the other post, I didn't mean to post it so many times) has given me a vba code, but I'll need to read up on vba before I can use it. Maybe I need to resolve the answer using multiple stages of formulae??? "Pete_UK" wrote: Which formula is this? Pete On Feb 12, 1:34 pm, Rachel7 wrote: I need to extend the formula to exclude multiple values, empty cells & zero values in the range. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a smallest date | Excel Worksheet Functions | |||
| XIRR 0.00% Return with Small First Deposit | Excel Worksheet Functions | |||
| formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
| return a cell contents as the result of usiing "small" | Excel Worksheet Functions | |||
| Return the smallest value | Excel Worksheet Functions | |||
Linear Mode
