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]

Haha will try to spell it out a little more in future!

 

[gaz_chops]

That was me not reading properly

Check uploaded file, let me know.

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

 

[dunmore83]

I copied the files across to my file & all works. Absolutely brilliant!!! Thanks.

However I adjusted the column headings on the AI Anlaysis sheet & it made everything disappear.

Are you able to make it work so I can add rows above row 10 on this sheet as I will need to add some extra rows at the top?

https://www.dropbox.com/s/tzfk5hf2rpjrouk/Gaz-Ages-Returned-3.xlsx?dl=0

 

[gaz_chops]

When you insert rows it was throwing the formula in D13, as everything depends on the value in that cell they all returned blanks, I've adjusted it so it should work.

https://www.dropbox.com/s/6ko8k1c3ckpqdhs/Gaz-Ages-Returned-3.xlsx?dl=0

 

[gaz_chops]

Use this one, I adjusted it in case you add rows to AI-Alrpo-Data

https://www.dropbox.com/s/6ko8k1c3ckpqdhs/Gaz-Ages-Returned-3.xlsx?dl=0

 

[dunmore83]

Excellent.

I need one more criteria to be incorporated into the formula in column D of the Dates-Anyalsis worksheet!

Which is.... if an AI date is found between the dates in S1 & S2 then this number (i.e. ear tag) needs to be excluded from column D.

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

 

[gaz_chops]

Mmm tricky, leave it with me.

Just to confirm, the AI date is the date in AI-02-Dates?

 

[dunmore83]

Yes that's correct. Thanks!!!

 

[gaz_chops]

TBH not sure it is do-able (by me anyway!), i'll take a look in the morning and let you know.

The problem i see is that the Tag has to be retrieved before a check can be made on those new dates, I can't see how it is possible to exclude the tag after! Unless we just make the cell a different colour of flag in some other way!

 

[gaz_chops]

OK think i've done it!
I had to add a formula to Column A on AI-Alrpo-Data, this checks if the tag has a date within the exclude range and places a count in Col A.
I then amended the formula in D3 to only return Tags which are a zero in Col A.

Appears to work, if it is acceptable!

If it is then check that it works as you want it to.

[TABLE="width: 159"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cow No.[/TD]
[TD]Cow ID[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]329[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]11212[/TD]
[TD]SIER[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]347[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]1725[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]134[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] 1.00[/TD]
[TD]101[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]2226[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]1807[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]3056[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] 1.00[/TD]
[TD]1738[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]870[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]1044[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]1741[/TD]
[TD]DUN[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]9503[/TD]
[TD]SIER[/TD]
[/TR]
[TR]
[TD="align: right"] 1.00[/TD]
[TD]230[/TD]
[TD]SIER[/TD]
[/TR]
[TR]
[TD="align: right"] -[/TD]
[TD]3029[/TD]
[TD]DUN[/TD]
[/TR]
</tbody>[/TABLE]

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