![]() |
#2
|
||||
|
||||
![]()
Hi
your first interval 0-300 is not consistent with the second example. It is 301 numbers long and 301-600 is 300 numbers long If we discard 0 to make things consistent try Code:
=(FLOOR(A1-1,300)+1)&"-"&CEILING(A1,300)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Categories disappear | PattiL | Outlook | 0 | 08-05-2011 08:34 AM |
Using categories | Matelot | Outlook | 3 | 10-14-2010 07:32 PM |
Categories disappeared? | markg2 | Outlook | 1 | 08-02-2010 03:24 PM |
Categories using IMAP | Shawn76 | Outlook | 2 | 07-24-2010 03:13 PM |
![]() |
herbycanopy | Excel | 3 | 04-09-2010 05:58 PM |