Hi to all!
I have a data set with Countries, operators and dates. I know want to have the highest date (most recent) per group into a new column that only contains most the recent dates across groups. The same with the 2nd ... nth highest dates. There's about up to 10 of those different dates. The dates within a country group and in one column should obviously be constant.
Country | Operator | Date | highest date | 2nd highest date | 3 highest date |
US | AT&T | 2017 | 2017 | 2016 | 2004 |
US | Sprint | 2016 | 2017 | 2016 | 2004 |
US | AT&T | 2004 | 2017 | 2016 | 2004 |
UK | EE | 2004 | 2004 | 2001 | . |
UK | O2 | 2001 | 2004 | 2001 | . |
France | Orange | 2012 | 2012 | . | . |
France | SFR | 2012 | 2012 | . | . |
Thanks a lot!
Bests
Comment