If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
Offset function referencing worksheet | Jeff | General Discussion | 1 | September 11th, 2005 07:01 PM |
Can the offset worksheet function reference another worksheet | AlistairJ | Worksheet Functions | 2 | May 9th, 2005 06:18 PM |
Worksheet Function - Find? | DAA | Worksheet Functions | 2 | February 24th, 2005 04:15 PM |
TREND worksheet function for polynomials | Jerry W. Lewis | Worksheet Functions | 3 | April 7th, 2004 12:54 AM |