Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a conditional screen based on multiple criteria
I am in the begining stages of creating a screen that will screen data on sheet2 based on conditions entered on sheet1. The data on sheet2 is formatted consistantly, as is the input layout on screen1. The problem I think I'm going to face, is there are about 20 possible criteria, and thousands of data on sheet2. Right now, I think I am limited to using If statements to screen, due to my ability, and this will make for alot of if statements. Most likely will kill my Excel (past experience). I am dealing with stock characteristics, to give you an idea of what I'm trying to accomplish. Example setup: Sheet 1 (Fields(A:A)and Requirements(B:B)) Name Price 100 Volume P/E <50 Sheet 2 will have the data, with different stocks down the rows, and the fields across the top. Any advice on how to go about this? Is it possible to screen on only the fields that have inputs, versus running if statements on all possible criteria fields? Any and all help is appreciated. I will clarify anything if neccessary. Thanks -- Paul987 ------------------------------------------------------------------------ Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850 View this thread: http://www.excelforum.com/showthread...hreadid=517367 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a conditional screen based on multiple criteria
check out this site on conditional formatting and a global sense:
http://www.xl-logic.com/pages/tips.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN | Excel Worksheet Functions | |||
Conditional Formating based on multiple criteria | Excel Discussion (Misc queries) | |||
Creating function to insert data based on criteria | Excel Worksheet Functions | |||
Creating combinations based on a criteria | Excel Programming | |||
[VBA] Creating sheets based on criteria | Excel Programming |