Pivot Table Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi, I think is easier to make a reference to the data base instead of the
PTable.

does it help?
Marcelo

"carl" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format Question 3
Macro Question 8
Scrabble Value calculation for Welsh words 0
Displaying Cells on a Different Worksheet based on Criteria 3
Excel Macro or Formula Question 1
2 conditions for condition formatting 5
Pivot Tables--Counting Blank Cells 2
Sumproduct - sort of 5

Back
Top