Forum

Create a Pivot that...
 
Notifications
Clear all

Create a Pivot that filters the columns

2 Posts
2 Users
0 Reactions
62 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hello, my name is Maurizioi, And my New Problem and this: I would like to make a ranking (of which I attach the file) where the residents of 5 and 4 years preceded those of 3 years and with the same score are allowed those with seniority. Do you need to filter the columns or is there any better formula or function? Thank you

 
Posted : 13/02/2018 5:12 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hello, my name is Catalin.

First, add a column with this formula to determine the age: =(TODAY()-C2)/365.25

If you sort the new column Largest to Smallest, is the result what you need?

 
Posted : 06/03/2018 1:22 am
Share: