ExcelBanter - Pivot Table Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table Question (https://www.excelbanter.com/excel-worksheet-functions/92679-pivot-table-question.html)

carl

Pivot Table Question

I have a Pivot Table with a colum like this:

549
910
50
919
980
642
937

I have another list like ColA below:

980 Y
642 Y
937 Y
234 N

I amtrying to find a formula for ColB above. The formula returns Y if the
value in ColA appears in the Pivot Table.

Thank you in advance.

Marcelo

Pivot Table Question

Hi, I think is easier to make a reference to the data base instead of the
PTable.

does it help?
Marcelo

"carl" escreveu:

I have a Pivot Table with a colum like this:

549
910
50
919
980
642
937

I have another list like ColA below:

980 Y
642 Y
937 Y
234 N

I amtrying to find a formula for ColB above. The formula returns Y if the
value in ColA appears in the Pivot Table.

Thank you in advance.

All times are GMT +1. The time now is 02:51 PM.