Dear all
i fact a issue when i try to import excel into google
My calculation not more longer work !
.
Master DATA
_______________
Site Dept Date Score 5s
Spain Sales 04.01.2016 3,1
Germany Infra 01.02.2016 2
Netherland Sales 01.01.2016 1,3
MA Tech 03.01.2016 4,5
TR Tech 01.01.2016 1
Spain Tech 15.01.2016 2,1
Spain Sales 16.01.2016 1,2
MA Tech 17.01.2016 5
France Management 18.01.2016 3
Germany Infra 19.01.2016 5
US Management 20.01.2016 4
Germany Infra 21.01.2016 1
France Management 22.01.2016 6
France Management 23.01.2016 7
France Management 24.01.2016 3
Germany Infra 25.01.2016 12
France Management 26.01.2016 31
Germany Infra 27.01.2016 33
France Management 28.01.2016 2
France Management 29.01.2016 1
Egypt Infra 30.01.2016 8
Mubai Management 31.01.2016 5
AP Infra 01.02.2016 3
AP Infra 02.02.2016 4
US Management 03.02.2016 31
US Management 06.02.2016 50
US Management 07.02.2016 61
US Infra 08.02.2016 71
No i want to create a a sheet witch calucate
Site & DEPT & last entry & Score
mean when i have 3 entries with US Management i only want to have the lasted Date : 07.02.2016 an the score 61
US Management 07.02.2016 61
I excel it works but not in sheets
Bookmarks