=IF(AND(D22="left", C22="C"), COUNTIF($F$5:F21, ">0")+1, "")

This has now taken over as the most complex function I've ever written in Excel. It's a baby step in my attempt to learn to program. Eventually, I'd like to be sufficient in Matlab and possibly Python. And though it isn't really that complicated, it took me an hour or so of staring and googling to figure out how to twist Excel functions to do my bidding. Probably would have taken 3 minutes in Matlab or python....


Design of Blogger Template | To Blogger by Blog and Web