I am trying to bring top line of one of the second tab (just in the Most Improved) to the main tab
As you see in the example, the most improved is 'Y' yet when you look at the Most Improved tab the top line is actually 'N' (identity's have been hidden to protect the innocent)
I have to manually hide those from the Most Improved tab, if they are not eligible to win.
I know I can paste this information, just looking to see if excel can help me out
Thanks in advance!!
Your description is not clear to me
I don't know what you are trying to do
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
In short I am needing the yellow cell information on the second tab showing in the black cells
Re: Not Including Hidden Cells
Here is the updated example
Unable to locate the black cells in your workbookOriginally Posted by ioswoody
B2 formula
Formula:
Please Login or Register to view this content.
C2 formula
Formula:Please Login or Register to view this content.
Last edited by humdingaling; 05-26-2015 at 01:37 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks!! So I'm assuming the 104 in the formula means the top line of data/results?B2 formula
Formula:Please Login or Register to view this content.
C2 formula
Formula:Please Login or Register to view this content.
Subtotal 104 = MAX ignore hidden values
http://www.techonthenet.com/excel/formulas/subtotal.php
you are the highest Number (Column I) of shown region which coincidentally is how you have sorted it by
in the case where there are more than one...it takes the 1st value..which works for your example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks