Based on your sample
Note: your 180-210 should be 181-210 I believe.![]()
L2: =FLOOR(MAX(0,K2-1),30)+(K2>30)&"-"&CEILING(MAX(1,K2),30) copied down
Based on your sample
Note: your 180-210 should be 181-210 I believe.![]()
L2: =FLOOR(MAX(0,K2-1),30)+(K2>30)&"-"&CEILING(MAX(1,K2),30) copied down
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks