| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function for range of numbers
I'm trying to find an Excel formula which will give me the total number
of entries in a range. 1-4 should provide 4 2 should provide 1 345 should provide 1 1-17 should provide 17 13-23 should provide 11 So the actual value of the number is not important but I need to return the number in the range of values. Any help much appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet function for range of numbers
=IF(NOT(ISNUMBER(FIND("-",A1))),1,MID(A1,FIND("-",A1)+1,255)-LEFT(A1,FIND("-
",A1)-1)+1) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "brendan_doc" wrote in message ups.com... I'm trying to find an Excel formula which will give me the total number of entries in a range. 1-4 should provide 4 2 should provide 1 345 should provide 1 1-17 should provide 17 13-23 should provide 11 So the actual value of the number is not important but I need to return the number in the range of values. Any help much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The sum and average function view all numbers as zero?? | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Help with function to sum values in a worksheet depending on account number | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
