-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
0-5
-
B
Blanks in a pivot table
I have a project due at work in 2 hours so I'm hoping I can get some help before that! I have a huge set of data with some blanks. See example below: <tbody> Order # Shipping Cost Our Charge Province Weight Class 100 $20 $10 ON 0-5 101 $10 BC 0-5 102 $30 $10 PQ 5-10...- bigdan
- Thread
- $10 0-5 category class number
- Replies: 2
- Forum: Excel Questions
-
=ceiling(eomonth(a2,0)-5,7)+6
good evening , i have send my timehasheets at the end of each week. a2 has the week commencing date (ie 3/9/18) and b2 has the formula =CEILING(EOMONTH(A2,0)-5,7)+6 . I would like to be able to display what week it was for the period between a2 & b2 IE 1 of 4 / 2 of 4 etc ( or 1 of 5 etc...- Trevor3007
- Thread
- 0-5 7+6 =ceilingeomontha2 month week
- Replies: 6
- Forum: Excel Questions
-
A
Regular Expresions
I'm trying to understand this pattern RE.Pattern = "^[A-Z|b]?\d+\. .*:[0-5]\d$" Is the following correct and could you tell me what \. . means ? ^ Start [A-Z|b] Any char "A-Z" or "b" ? all before zero Or one times \d+ Matches a single digit one or more \. . ???? *:[0-5]...- AlexanderBB
- Thread
- 0-5 colon digit matches single
- Replies: 5
- Forum: Excel Questions
-
S
if formula based on ranges
Hi there, I want to input a formula that looks at column A and assigns a group. So if(A2>,"0-5",if(A2<=0,"6-10",if(A2<=5,"11-15",IF(A2<=0,"16-30",if(A2>50,">50"))))) How can I write this correctly? Thanks!- snash
- Thread
- 0-5 assigns column formula ifa2
- Replies: 7
- Forum: Excel Questions
