# Recent content by Sam Mathai Chacko

1. ### Find Month Between two specified date

A simple text formula should do the trick =TEXT(A2-7,"mmm yy")
2. ### Hi Hui, Hope you are doing well. I haven't been able to spend much time online, but I got one...

Hi Hui, Hope you are doing well. I haven't been able to spend much time online, but I got one of your posts (http://chandoo.org/wp/2015/03/27/conditionally-format-chart-backgrounds/), and thought I'll share one more solution. But I don't know how to attach the file. If it's fine with you, I...
3. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

This keeps getting better. 64 Characters =SUM(OFFSET(C2,,,IFERROR(MATCH(0,N(LEN(A2)<LEN(A3:A\$20)),),19)))
4. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

Thanks Faseeh for the feedback. Just realized that I could take out 5 more characters :) =SUM(OFFSET(C2,,,MATCH(0,N(--SUBSTITUTE(0&A3:A\$22,".",0)>--SUBSTITUTE(A2,".",0)),)))
5. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

No takers? I understand it's relatively simple compared to a lot of the other formula challenges, but that shouldn't make you abstain! Well, I'll go ahead and post my solution =SUM(OFFSET(C2,,,MATCH(0,--(--SUBSTITUTE(0&A3:A\$22,".","0")>--SUBSTITUTE(A2,".","0")),)))
6. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

Narayan Of course that will work, but again, the idea is that the levels could be as long is it can... maybe 3 digits or 4 digits. Your original formula is fundamentally correct, but maybe could be a little more generic, to the extend that it considers any number of levels, and not just up to...
7. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

I might add that the only problem being, if the level exceeds to two digits, like 10, 11 or above, then the solution might not work exactly as intended
8. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

Narayan, that looks very much right. And shorter too. Great :) ... any other attempts anyone?
9. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

Sure Narayan. File attached in OP.
10. ### Formula Challenge 024 - Sum Of Items Based On Hierarchy Level

So we haven't had a new challenge in a while, so I thought I'll remind people that we have a section of the forum to pick your brains, by posting the following formula based challenge. I came across this in VBAExpress; so the credit for the question goes to the OP. So anyway, the challenge is...
11. ### Ribbon DatePicker Calendar Control For Excel 2007-2010

Thanks Bob for the kind feedback. Will certainly post here if I get around with further tweaks.
12. ### retrieving data from mails(outlook) using excel/vba

dan, I am not sure mate. I think I just about manage to get by. :)
13. ### retrieving data from mails(outlook) using excel/vba

Good to be back after a while, though I don't know for how long. So first thing's first.... webmax, were you able to get it to work eventually, or did you need any help. Cheran, can you explain your requirement. What I think you want to do is to push data in to different workbooks for each...
14. ### How does this code open up another file?

And yes, sHistFile is getting it's value from the range Range("rngHistFile") which is in sheet contained in the variable shtHistStock
15. ### How does this code open up another file?

Yes, you can add a line MsgBox sHistFile within that sub-routine somewhere to throw you a message with the content of that variable. Alternatively, you could use Debug.Print sHistFileand go to the immediate window in the vba editor by pressing CTRL+G