GerryZ
Well-known Member
- Joined
- Jul 4, 2014
- Messages
- 1,224
- Office Version
- 365
- Platform
- Windows
hello Excel gurus
I'm stuck
All I need a formula in F2 to copy across and down that choose
from the first criteria (AAA) the oldest date in (AAA) and than ritrieve the name of the student and the corrisponding date
I Made a formula with INDEX MAX IF but does't work
I'm stuck
All I need a formula in F2 to copy across and down that choose
from the first criteria (AAA) the oldest date in (AAA) and than ritrieve the name of the student and the corrisponding date
I Made a formula with INDEX MAX IF but does't work
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | criterio | student | datea | criterio | student | oldest data | |||
2 | aaa | student1 | 15/01/2015 | aaa | student2 | 17/01/2018 | |||
3 | aaa | student2 | 17/01/2018 | bbb | student5 | 22/01/2016 | |||
4 | aaa | student3 | 16/01/2015 | ccc | student11 | 12/04/2016 | |||
5 | bbb | student4 | 15/01/2014 | ||||||
6 | bbb | student5 | 22/01/2016 | ||||||
7 | bbb | student6 | 18/01/2015 | ||||||
8 | bbb | student7 | 18/01/2014 | ||||||
9 | bbb | student8 | 21/01/2014 | ||||||
10 | ccc | student9 | 07/06/2015 | ||||||
11 | ccc | student10 | 14/07/2015 | ||||||
12 | ccc | student11 | 12/04/2016 | ||||||
13 | ccc | student12 | 13/02/2015 | ||||||
14 | ccc | student13 | 11/03/2015 | ||||||
Sheet5 |