Extract a list based on a criteria

[amir9s]

Hi all,

I'm trying to extract a list from a couple of columns.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Documents[/TD]
[TD="align: center"]Required?[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Form 1[/TD]
[TD="align: center"]Yes[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Form 2[/TD]
[TD="align: center"]Yes[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Form 3[/TD]
[TD="align: center"]No[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

First column has a list of all the forms (one blank row after each form).
Column B indicated whether that form is required (I already made it a drop-down menu for Yes and No).

I'd also like to make sure no duplicates will be listed in case there are any duplicate forms. and also don't count any blanks since every other row is blank.

I'll be using this formula in another sheet to list only the form that are required (Basically say "Yes" in front of it).

Any help is much appreciated. Thank you.

 

[JLGWhiz]

1. Select columns A and B with the mouse pointer by left clicking A and drag over to B.
2. Click 'Data' on the ribbon, then click the Filter icon.
3. Click the arrow displayed in cell B1, then click the check box beside 'yes' to add a check mark and clear any other checkboxes if they are checked, then click OK.
4. Select review the items that are displayed to be sure it filtered correctly then copy the displayed items to the second sheet.
5. With the second sheet displayed as the active sheet, under 'Data' on the ribbon, click 'Remove Duplicates' and select your parameters, then click OK..
6. You should be all set.

 

[amir9s]

1. Select columns A and B with the mouse pointer by left clicking A and drag over to B.
2. Click 'Data' on the ribbon, then click the Filter icon.
3. Click the arrow displayed in cell B1, then click the check box beside 'yes' to add a check mark and clear any other checkboxes if they are checked, then click OK.
4. Select review the items that are displayed to be sure it filtered correctly then copy the displayed items to the second sheet.
5. With the second sheet displayed as the active sheet, under 'Data' on the ribbon, click 'Remove Duplicates' and select your parameters, then click OK..
6. You should be all set.

Thank you for your response. However, I need it automatically do it. basically a formula in my summary sheet that extracts that list from my Forms tab.