Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
static69
 
Posts: n/a
Default Displaying data based on a TRUE/FALSE value in a cell


I have 3 sheets with peoples names and several test scores for each
person on it. (A3:O3 would be one persons data persay.) Each person has
a checkbox next to it to identify if they are eligible for awards. This
check box turns the value of cell A1 to TRUE if checked and FALSE if
unchecked. I want a sheet that will show all of the peoples names from
each of the three sheets that has a FALSE value in column A. I only
need columns B, C, and O displayed on the new page. If at all possible
can make them automatically show in order from the highest to lowest
Value in column O?


--
static69
------------------------------------------------------------------------
static69's Profile: http://www.excelforum.com/member.php...o&userid=11075
View this thread: http://www.excelforum.com/showthread...hreadid=375237

  #2   Report Post  
MrShorty
 
Posts: n/a
Default


Would some kind of auto/advanced filter serve your purposes? For
example, it would be pretty easy to set up an autofilter to show all
the rows for which A1=TRUE, then hide the columns you don't want to
show.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=375237

  #3   Report Post  
static69
 
Posts: n/a
Default


That sounds like an answer to me, yet when i try to do this i can not it
to work. Can I please get a quick rundown of how to set up the auto
filter? I have never used it before.


--
static69
------------------------------------------------------------------------
static69's Profile: http://www.excelforum.com/member.php...o&userid=11075
View this thread: http://www.excelforum.com/showthread...hreadid=375237

  #4   Report Post  
mangesh_yadav
 
Posts: n/a
Default


Select the header column, click on Data Filter AutoFilter.
Select the down arrow box for the true-false column and select true (or
false as required)

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375237

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull Current Month's Data Out of List - Repost Karl Burrows Excel Discussion (Misc queries) 4 May 3rd 05 01:06 AM
How do I validate data using different lists based on the data in. Shannon Excel Discussion (Misc queries) 1 March 28th 05 05:55 PM
Hide column based on data value Jay Excel Discussion (Misc queries) 1 March 25th 05 02:40 AM
how do I show a picture in excel based on cell data Wishing to Excel Excel Discussion (Misc queries) 2 January 10th 05 05:39 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"