ExcelBanter

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rank (https://www.excelbanter.com/excel-discussion-misc-queries/1048-rank.html)

A Lesner

Rank

I want to use the rank formula in a pivot table.

Frank Kabel

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.

Peo Sjoblom

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.

All times are GMT +1. The time now is 04:50 AM.