Everything with Excel has pretty much been trial and error.
Always found macros more interesting than formulas, would see a question in the forums that sounded interesting and dissect how others approached solving it.

Anyway, glad I was able to assist and good luck with your project.