Hi,
I have written the following formula:
=INDEX('Daily Breakdown'!AD1:AD1000,COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0"))
this returns the last value in column AD which is not 0.
However I want this to return the bottom/last value based on the value in column B
So if column B is equal to certain value in a different tab then throughout range AD1:AD1000 return the last value if this is true.
So i kinda want to do index(AD1:AD1000,Match('Monthly Summary Tab'B21,B3:B100),0)*/(COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0")),1)
Though im pretty sure that doesn't work but that kind of thing. hope that makes sense
Just to clarify i wish to return the last value in the ad (Monthly tab) column if the range in cell b3:b100 (monthly tab) is equal to that of the value in B21 (daily tab) AND the value is not equal to 0.
I have written the following formula:
=INDEX('Daily Breakdown'!AD1:AD1000,COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0"))
this returns the last value in column AD which is not 0.
However I want this to return the bottom/last value based on the value in column B
So if column B is equal to certain value in a different tab then throughout range AD1:AD1000 return the last value if this is true.
So i kinda want to do index(AD1:AD1000,Match('Monthly Summary Tab'B21,B3:B100),0)*/(COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0")),1)
Though im pretty sure that doesn't work but that kind of thing. hope that makes sense
Just to clarify i wish to return the last value in the ad (Monthly tab) column if the range in cell b3:b100 (monthly tab) is equal to that of the value in B21 (daily tab) AND the value is not equal to 0.