LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default yes/ No on multiple sheet

I am trying to make a spread sheet so if for example on sheet 1 I have

A B C D
1 Big $5 3
2 Medium $3 5 yes
3 Small $1 4

I have a "yes" for the Medium row, How do I make it so that only the medim
row shows up on sheet 2 but if the other 2 would have "yes" in the D column
they would too?
 
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
Average Over Multiple Sheet Tabs with Multiple Values Karen Excel Worksheet Functions 6 February 4th 09 02:29 PM
Compilation sheet representing multiple data from multiple other s Chris Cornell Excel Discussion (Misc queries) 0 October 31st 08 06:51 PM
multiple cell reference from sheet to sheet KMR R.A. Excel Worksheet Functions 0 May 29th 08 12:48 AM
lookup single value in one sheet, return multiple results from theother sheet Chuck[_3_] Excel Worksheet Functions 1 April 4th 08 06:17 AM
Create multiple sheet tabs from multiple cells. Robert Maddox Excel Worksheet Functions 17 November 14th 07 10:28 PM


All times are GMT +1. The time now is 10:20 PM.

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

About Us

"It's about Microsoft Excel"