View Single Post
  #4   Spotlight this post!  
Unread 04-01-2006, 03:00
sanddrag sanddrag is offline
On to my 16th year in FRC
FRC #0696 (Circuit Breakers)
Team Role: Teacher
 
Join Date: Jul 2002
Rookie Year: 2002
Location: Glendale, CA
Posts: 8,510
sanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond reputesanddrag has a reputation beyond repute
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.
Attached Files
File Type: xls cell_visibility_2.xls (18.0 KB, 175 views)
__________________
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