Index IsNumber Data Anaysis

[dunmore83]

Hoping you might be able to provide some assistance on another part of the same workbook?!! If only you were in Australia I could attempt to send you some fresh milk

Anyways if your willing the 1st part I need you to look at is the formula in column D of the 1st worksheet... the problem here is that I don't want the rows with no data. Is it possible somehow to have only have rows when the formula returns a numerical value ??

https://www.dropbox.com/s/75bv2uwr7nbhtsh/Gaz-AI-Analysis.xlsx?dl=0

 

[dunmore83]

This one should be quite straight forward!!

Just need a formula to go in column AJ of the PD-01-Dates worksheet that will pull the most recent AI date from the AI-Dates sheet for any particular cow. Only tricky part is can you make it so if a cow is inseminated again & preg tested again then the previous data doesn't change?

i.e.
1701
01-05-15 AI #1
13-07-15 Preg Test Date
So last insem at this date would be 01-05-15

Then
1701
01-06-15 AI #2
15-08-15 Preg Test Date
So last insem at this date would be 15-08-15