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...
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
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...
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...
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...
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
Lori, yes I agree about the row location. But thanks a lot for that innovative use of FREQUENCY. That would have never occured to me!
Sajan, here's a shorter version of your formula
Abhijeet, basically, this is what my formula is doing
I'm sure you can make out what's happening in there now. :)