Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I want to use the rank formula in a pivot table.
|
#2
![]() |
|||
|
|||
![]()
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "A Lesner" schrieb im Newsbeitrag ... I want to use the rank formula in a pivot table. |
#3
![]() |
|||
|
|||
![]()
There is no built in RANK function in a pivot table, you need to use it outside
of the table. If you only want to see largest, second largest etc you can sort descending Regards, Peo Sjoblom "A Lesner" wrote: I want to use the rank formula in a pivot table. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
pivot table - Rank | Excel Discussion (Misc queries) | |||
Sorting Problems | Excel Discussion (Misc queries) |