AlKey - I did CSE the formula. However, I continued tweaking it, and finally go it to work this morning.
However, now I'm having another problem. The original goal (which I did not post about) was to write a formula that would display the account # of the highest single cost during a given period (in my example July 2013). After I got the above code to work, I began on the second part. I finally got the following to work on the same sheet as the data. (This formula is entered as a CSE).
Formula:
=INDIRECT(CONCATENATE("D",MATCH(MAX(IF((MONTH(A2:A10000))=7*(YEAR(A2:A10000)=2013),P2:P10000,"-")),P2:P10000,0)+1))
However, when I take the same formula and move it to another worksheet and adjust the cell references I get a value of 0.
Formula:
=INDIRECT(CONCATENATE("D",MATCH(MAX(IF((MONTH(Archives!A2:A10000))=7*(YEAR(Archives!A2:A10000)=2013),Archives!P2:P10000,"-")),Archives!P2:P10000,0)+1))
Again, this code is entered as a CSE value.
Any ideas why its not working. The only thing that changed was moving it to a new sheet, and the updated cell references should have accounted for that.
Bookmarks