Thread: Controlling visibility of cells in Excel
View Single Post
  #6   Spotlight this post!  
Unread 05-01-2006, 02:45
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
I tried Autofilter and didn't get much luck out of it. The IF function method is working perfectly. Go check out what I was up to in my new whitepaper "Object on an Incline Spreadsheet" It also makes one quite tricky but very creative (imho) use of Conditional Formatting and a use of cell data validation.

Excel is a much more powerful program than most people know. I'm glad I'm finally getting a chance to explore it in more depth than just basic arithmetic and graphs.
__________________
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