| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Question | Excel Discussion (Misc queries) | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| Pivot Table Question | Excel Discussion (Misc queries) | |||
| Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
Linear Mode
