E
EngelseBoer
hi, please help
i have a database something like the below, (but 36,000+ rows/animals)
and i need to run a script to verify that Dams are female (and Sires are male)
i need column 5(E) (here) to index row A and match with row D - similar to
=IF(X2="","",INDEX(Y:Y,MATCH(X2,Z:Z,0)))
but only return her name if her sex in B = Dog (or simply say ERROR)
i.e. search the Dam's name cloumn 4 (D)
find her name in column 1 (A) -
compare column 2 (B) and report back in colum 5(E) if she is not a "bitch"
example "Le Grange Tessa" is a dam - but is a dog
Name Sex Sire Dam
Bob At Quovadis Dog Roodebult Simba Le Grange Tessa
Roodebult Simba Dog Byrne Bobby Sebastiaan Tessa
Byrne Bobby Dog Mizpah Thor Slamat Lyla
Mizpah Thor Dog
Slamat Lyla Bitch
Sebastiaan Tessa Bitch Sebastiaan Monty Hansom Sophfie
Sebastiaan Monty Dog
Hansom Sophfie Bitch
Le Grange Tessa Dog Ferrou Bruno Jess Cloe
regards
EngelseBoer
i have a database something like the below, (but 36,000+ rows/animals)
and i need to run a script to verify that Dams are female (and Sires are male)
i need column 5(E) (here) to index row A and match with row D - similar to
=IF(X2="","",INDEX(Y:Y,MATCH(X2,Z:Z,0)))
but only return her name if her sex in B = Dog (or simply say ERROR)
i.e. search the Dam's name cloumn 4 (D)
find her name in column 1 (A) -
compare column 2 (B) and report back in colum 5(E) if she is not a "bitch"
example "Le Grange Tessa" is a dam - but is a dog
Name Sex Sire Dam
Bob At Quovadis Dog Roodebult Simba Le Grange Tessa
Roodebult Simba Dog Byrne Bobby Sebastiaan Tessa
Byrne Bobby Dog Mizpah Thor Slamat Lyla
Mizpah Thor Dog
Slamat Lyla Bitch
Sebastiaan Tessa Bitch Sebastiaan Monty Hansom Sophfie
Sebastiaan Monty Dog
Hansom Sophfie Bitch
Le Grange Tessa Dog Ferrou Bruno Jess Cloe
regards
EngelseBoer