Return Unique Values If

[collegeitdept]

Does any on know of a formula that will only return the values in Column B only if it has an "X" in column A (without skipping a row).


Reference List

A B
x Item 1
Item 2
Item 3
Item 4
Item 5
x Item 6
x Item 7
x Item 8
Item 9
x Item 10



Returned values:

Item 1
Item 6
Item 7
Item 8
Item 10



Thanks.

 

[machopicho]

Bump

 

[snoopyhr]

Hope this helps :

Excel Workbook
	A	B	C	D	E
1	Col1	Col2	*	Item of Interest	x
2	x	Item 1	*	Count of items	5
3	Other	Item 2	*	*	*
4	Other	Item 3	*	Extracted	*
5	Other	Item 4	*	Item 1	*
6	Other	Item 5	*	Item 6	*
7	x	Item 6	*	Item 7	*
8	x	Item 7	*	Item 8	*
9	x	Item 8	*	Item 10	*
10	Other	Item 9	*	*	*
11	x	Item 10	*	*	*
Sheet2

 

[machopicho]

More simple?

 

[snoopyhr]

For Excel 2003
1- click anywhere in your data table
2-Click on data
3- click on auto filter
4-from the first cloumn click on the arrow and select "X"
highlit the shown data , copy it and paste it where you want it to reside.

you need to this everytime your data changes. so make sure you do this everytime new data added.

HTH.

 

[Smitty]

Please stick to your Original Thread.