Problem
What excel function should l use if l want to find the household that has the biggest age difference between the oldest person and the youngest person in that house?
|
household number
|
persnum
|
psersonal number
|
household size
|
age
|
|
101051
|
1
|
10105101
|
1
|
92
|
|
101151
|
1
|
10115101
|
1
|
63
|
|
101201
|
1
|
10120101
|
1
|
56
|
|
101271
|
1
|
10127101
|
2
|
38
|
|
101271
|
2
|
10127102
|
2
|
25
|
|
101351
|
1
|
10135101
|
3
|
37
|
|
101351
|
2
|
10135102
|
3
|
14
|
|
101351
|
3
|
10135103
|
3
|
10
|