Lookup??

M

Mike Rogers

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
 
P

Peo Sjoblom

The absolute easiest way is to use data>filter>advanced 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 data>filter>advanced 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
 
M

Mike Rogers

Peo, thanks I'll give it a try. I appreciate your time and input!!!

Mike Rogers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top