Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Build a Table
Hi,
Is there a way to build a table based on a condition? so say i have the following table in one sheet (Sheet 1). What i would like to do is to create a new worksheet (Sheet 2) that would pull out the entire row if a certain condition was true. So if i wanted an even widget i would get the following in sheet 2: b 2 widget 10 a 1 widget 5 b 2 widget 10 c 1 widget 15 d 2 gadget 20 e 1 gadget 25 f 2 gadget 30 Thanks again, Josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different ways to build Pivot table | Excel Discussion (Misc queries) | |||
How do I build a sensitivity analysis table? | Excel Worksheet Functions | |||
Match 2 sheet and build table | Excel Discussion (Misc queries) | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
how can i build a three variable data table in excel ? | Excel Discussion (Misc queries) |