Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup??
If I have a table: Apples red 9 Oranges orange 6 Lemons yellow 2 Bananas yellow 1 Grapes green 8 on one sheet, and I'd like to display all lines that contain a number above 7 in Column C, on another sheet, how would I go about that? Mike Rogers -- The only dumb question is the one you did not ask. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup??
The absolute easiest way is to use datafilteradvanced filter
Make sure you have headers for all 3 columns like Fruit Colour Price or whatever, assume your example has those headers and is in Sheet1!$A$1:$C$6 in let's say F1 in the same sheet put Price and in F2 7 now go to Sheet2 (or whatever sheet you are using) select let's say A1, then do datafilteradvanced filter, click in the list range and then click sheet1 and select A1:C6, then in the criteria range select F1:F2 and finally select copy to another location and once again go to Sheet2 A1 by clicking sheet tab and cell, finally click OK, that will give you what you want without including advanced formulas that can slow down the workbook -- Regards, Peo Sjoblom "Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message ... If I have a table: Apples red 9 Oranges orange 6 Lemons yellow 2 Bananas yellow 1 Grapes green 8 on one sheet, and I'd like to display all lines that contain a number above 7 in Column C, on another sheet, how would I go about that? Mike Rogers -- The only dumb question is the one you did not ask. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup??
Peo, thanks I'll give it a try. I appreciate your time and input!!! Mike Rogers -- The only dumb question is the one you did not ask. "Peo Sjoblom" wrote: The absolute easiest way is to use datafilteradvanced filter Make sure you have headers for all 3 columns like Fruit Colour Price or whatever, assume your example has those headers and is in Sheet1!$A$1:$C$6 in let's say F1 in the same sheet put Price and in F2 7 now go to Sheet2 (or whatever sheet you are using) select let's say A1, then do datafilteradvanced filter, click in the list range and then click sheet1 and select A1:C6, then in the criteria range select F1:F2 and finally select copy to another location and once again go to Sheet2 A1 by clicking sheet tab and cell, finally click OK, that will give you what you want without including advanced formulas that can slow down the workbook -- Regards, Peo Sjoblom "Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message ... If I have a table: Apples red 9 Oranges orange 6 Lemons yellow 2 Bananas yellow 1 Grapes green 8 on one sheet, and I'd like to display all lines that contain a number above 7 in Column C, on another sheet, how would I go about that? Mike Rogers -- The only dumb question is the one you did not ask. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |