Choice List HELP!!

[eddieRoberts]

The IF Statement didnt work.

Ok, First, I have a worksheet with a list
Column A is the choice column
Column C is the descrition of the item

On a seperate worksheet within the same workbook I want to list everything that I have placed an X next to in column A on the above worksheet. Without any blank spaces.
Please Help Example below


A B C

x $50 Purse
x $100 Cat
$300 Fish
x $400 Barbie


So Purse,Cat and Barbie should show up on the other worksheet.

 

[Aladin Akyurek]

On 2002-10-23 15:30, eddieRoberts wrote:
The IF Statement didnt work.

Ok, First, I have a worksheet with a list
Column A is the choice column
Column C is the descrition of the item

On a seperate worksheet within the same workbook I want to list everything that I have placed an X next to in column A on the above worksheet. Without any blank spaces.
Please Help Example below


A B C

x $50 Purse
x $100 Cat
$300 Fish
x $400 Barbie


So Purse,Cat and Barbie should show up on the other worksheet.

Try applying Advanced Filter. & there is no need to start another thread on the same matter.

 

[eddieRoberts]

I am a little bit in the dark about the Advanced filter. Sorry about the new post.

Do you mean use =IF Sheet1!A1="x",C1
Then apply a filter?

 

[Yogi Anand]

Hi eddiRoberts:

Welcome to the Board!

I will do this by using DATA|FILTER|ADVANCED_FILTER -- see the following worksheet simulation

Book1
	A	B	C	D	E	F	G
1	Choice	Price	Description
2	x	$50	Purse		TRUE
3	x	$100	Cat
4		$300	Fish		Choice	Price	Description
5	x	$400	Barbie		x	$50	Purse
6					x	$100	Cat
7					x	$400	Barbie
8
9		sourceListinSheet1
10		criterionforAdvancedFilter
11		outputfromAdvancedFilter
Sheet8

</SPAN>

Please post back if you need further help on this.

Regards!

Yogi

 

[eddieRoberts]

Thats EXACTLY what I want

I am ignorant to the HTML EXEL example
Where do the formulas exist?

 

[Aladin Akyurek]

On 2002-10-23 15:39, eddieRoberts wrote:
I am a little bit in the dark about the Advanced filter. Sorry about the new post.

Do you mean use =IF Sheet1!A1="x",C1
Then apply a filter?

I see Yogi has already given a worked out response. If you want to have only the relevant names in a separate worksheet, read what follows...

Consider the sample you provided...

Book13
	A	B	C	D
1	Field1	Field2	Field3
2	x	50	Purse
3	x	100	Cat
4		300	Fish
5	x	400	Barbie
6
Sheet1

As you can see, the labels/fields in row 1 are distinctly formatted (a requirement)...

You want to filter out the names from records marked with an x in the first column... the following recipe should filter out the relevant names directly in Sheet2.

( 1.) In A1 in Sheet2 enter: Field1, which you format as bold and italic.
( 2.) In A2 enter: x (the marker)
( 3.) In A3 enter: Field3, which you format as bold and italic.
( 3.) Activate A3.
( 4.) Activate Data|Filter|Advanced Filter.
( 5.) Check Copy to another location as Action.
( 6.) Enter Sheet1!$A$1:$C$5 in the List range box.
( 7.) Enter Sheet2!$A$1:$A$2 in the Criteria range box.
( 8.) Enter Sheet2!$A$3 in the Copy to box.
( 9.) Leave Unique records only unchecked.
(10.) Click OK.

This is the result in Sheet2...

Book13
	A	B	C	D
1	Field1
2	x
3	Field3
4	Purse
5	Cat
6	Barbie
7
Sheet2

 

[Yogi Anand]

On 2002-10-23 16:02, eddieRoberts wrote:
Thats EXACTLY what I want

I am ignorant to the HTML EXEL example
Where do the formulas exist?

Hi eddieRoberts:

There is only one formula, as you can see in the worksheet simulation, and that is in cell E2. You should readup on DatA|Filter|AutoFilter and Advanced Filter in online help. However, here is a little step by step description

Begin Here

1. I have assumed your source data is in sheet1. I have shown the data in my worksheet simulation just to show what data is being used.
2. I am assuming you want to extract the data of interest (from sheet1) into sheet2.
3. So make sure you have your data (as shown in simulation) in your sheet1.
4. Then you go to sheet2, which would be blank to start off with ...
in cell E2 put the formula =Choice="x"
5. while you are in sheet2, click some where in a blank cell, and then do DATA|FILTER|ADVANCED_FILTER ... and you will see a dialog box pop up

use this dialogbox to say

Action ... select Copy_to_another_location
List_Range ... Sheet1!$A$1:$C$5
Criteria_Range ... $E$1:$E$2
Copy-To ... $E$4

and finally click on OK ... and you should see your data of interest extracted to cells E4:G7 -- if you do not see that process -- go to Begin Here!

Regards!

Yogi Anand

 

[Yogi Anand]

Hi Aladin:

My apologies ... I did not notice that you had already addressed eddieRobert's question while I was also trying to come up with a simple explanation for him how to do the Advanced Filter ... so he could duplicate what I shown in my simulation.

Regards!

Yogi Anand