Compare and display multiple rows

G

Greg

I have two sheets and I'm trying to figure a way to display multiple rows
from sht1 to sht2.
sht 2 A1=apple

sht1
A B C
1 apple grn 21
2 pear yel 22
3 orange org 23
4 apple red 24

sht2
A B C
1 apple
2 apple grn 21
3 apple red 24
How can I get sht2 to display rows of apples? thanks, greg
 
R

Ron Coderre

I'm pretty sure a Pivot Table would solve your dilema.

Use column headings above your data Fruit, Type, Amount, etc.

When setting the layout: ROW:Fruit,Type , DATA:Amount

Then you can select any combination of Fruits and Types to display.

Does that help?
 

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

Similar Threads

Compare two wk sheets with common data using copy paste macro 0
Why doesn't this work ? 2
Is there a formula that can do this? 3
Count to Table Format 0
Count no. of occurance in 2 dynamic columns within a data period 7
min in a subgroup 9
Autogroup then sum - can it be done? 5
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1

Top