Hi,
This has been driving me nuts, please can someone take a look.
Column U contains unique codes made up of parent codes and child codes as such:
[TABLE="width: 500"]
[tr][td]Code (Col U)
[/td][td]Parent
[/td][td]Date
[/td][td]Minimum
[/td][/tr][tr][td]TEST100
[/td][td]1
[/td][td]10-08-16
[/td][td]08-08-16
[/td][/tr][tr][td]TEST100.10
[/td][td][/td][td]08-08-16
[/td][td][/td][/tr][tr][td]TEST100.20
[/td][td][/td][td]25-09-16
[/td][td][/td][/tr][tr][td]TEST200
[/td][td]1
[/td][td]26-10-16
[/td][td]26-10-16
[/td][/tr][tr][td]TEST200.10
[/td][td][/td][td]28-10-16
[/td][td][/td][/tr][tr][td]TEST200.20
[/td][td][/td][td]10-11-16
[/td][td][/td][/tr]
[/TABLE]
It is the minimum column I am trying to achieve.
What I need is:
IF parent THEN search all codes in U6:U for codes containing the parent and return the minimum date.
The closest i have gotten is:
MIN(AB6:INDEX(OFFSET($U$6,0,0,COUNTA($U:$U)-COUNTA($U$1:$U$5),1),MATCH(TRUE,(OFFSET($A$6,0,0,COUNTA($U:$U)-COUNTA($U$1:$U$5),1)=1),0))),"")
A = parent column
U = code column
AB = dates
I would much appreciate some help here - thanks.