| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull info from separate worksheet based on given criteria
I have 2 worksheets. The first has a list of all projects and the second
needs to pull projects based on certain criteria. Worksheet #1 Project % $'s Date Proj #1 85% $$$ 10/15/08 Proj #2 17% $$$ 11/07/08 Proj #3 62% $$$ 09/29/08 Proj #4 99% $$$ 08/15/08 Proj #5 47% $$$ 12/15/08 Proj #6 89% $$$ 10/15/08 Proj #7 70% $$$ 10/15/08 From this worksheet i want to pull only those projects with a % higher than a given critieria. I would prefer to do this with a formula as result needs to be live. Any help that can be given is greatly appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing totals on separate worksheet based on 2 criteria | Excel Discussion (Misc queries) | |||
| how do i pull info from one worksheet to another? | Excel Discussion (Misc queries) | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| How do I pull a date from a separate worksheet using the IF functi | Excel Worksheet Functions | |||
| Can a worksheet pull from a specific cell value in a separate wrks | Excel Worksheet Functions | |||
Threaded Mode
