|
Re: Controlling visibility of cells in Excel
Quote:
|
Originally Posted by Karthik
The second version calculates the data each time. Given an inputted limit and increment (adds some versatility), it generates your list of angles. The formulas are all their for you to play with. I find Excel much easier to learn via re-engineering as opposed to explainations. So I've attached it.
|
That's almost exactly what I wanted. However, I didn't like the sort of back door route of using the hidden "A" column. So, I devised a better IF statement to take care of that. Take a look.
__________________
Teacher/Engineer/Machinist - Team 696 Circuit Breakers, 2011 - Present
Mentor/Engineer/Machinist, Team 968 RAWC, 2007-2010
Technical Mentor, Team 696 Circuit Breakers, 2005-2007
Student Mechanical Leader and Driver, Team 696 Circuit Breakers, 2002-2004
|