Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
I have a Pivot Table below where column 1 has the value 'a' for my 3 rows of
data. How can I do a vlookup on column 1 with the value 'a' and column 2 with the value 'e' and return my total of 3? Count of 3 1 2 Total a d 2 e 3 n 1 a Total 6 Grand Total 6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
If you type an "=" and click the cell in the table you should get a
dynamic formula: =GETPIVOTDATA("3",$A$1,"1","a","2","e") Then you could replace "a" and "e" by cell references Alternatively, if you want to use lookup functions try: =LOOKUP(2,1/(LOOKUP(ROW(A2:A5),ROW(A2:A5)/(A2:A5<""),A2:A5)="a") /(B2:B5="e"),C2:C5) The key to the formula is: LOOKUP(ROW(A2:A5),ROW(A2:A5)/(A2:A5<""),A2:A5) which fills in blanks in the first column. Terence wrote: I have a Pivot Table below where column 1 has the value 'a' for my 3 rows of data. How can I do a vlookup on column 1 with the value 'a' and column 2 with the value 'e' and return my total of 3? Count of 3 1 2 Total a d 2 e 3 n 1 a Total 6 Grand Total 6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions |