Choice List HELP!!

eddieRoberts

New Member
Joined
Oct 22, 2002
Messages
7
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.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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

New Member
Joined
Oct 22, 2002
Messages
7
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi eddiRoberts:

Welcome to the Board!

I will do this by using DATA|FILTER|ADVANCED_FILTER -- see the following worksheet simulation
Book1
ABCDEFG
1ChoicePriceDescription
2x$50PurseTRUE
3x$100Cat
4$300FishChoicePriceDescription
5x$400Barbiex$50Purse
6x$100Cat
7x$400Barbie
8
9sourceListinSheet1
10criterionforAdvancedFilter
11outputfromAdvancedFilter
Sheet8
</SPAN>

Please post back if you need further help on this.

Regards!

Yogi
 

eddieRoberts

New Member
Joined
Oct 22, 2002
Messages
7

ADVERTISEMENT

Thats EXACTLY what I want

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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
ABCD
1Field1Field2Field3
2x50Purse
3x100Cat
4300Fish
5x400Barbie
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
ABCD
1Field1
2x
3Field3
4Purse
5Cat
6Barbie
7
Sheet2
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,482
Members
414,144
Latest member
UDFNewbie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top