Help with an index formula

[tacitend]

Hi all,

I've been attempting to find a way to automate and find the difference of the last two columns in a sheet that increases weekly. I have INDEX(AL7:NZ7,1,COUNTA(AL7:NZ7)-1) and INDEX(AL7:NZ7,1,COUNTA(AL7:NZ7)-2) The issue I am running into is that I have the solution of the two columns in the range of the index, ex. AM-AL where the solution is located in cell AN. When I do it this way it runs into circular error but I cant put the solution anywhere but at the end of each row. Is there a better way to exclude that cell or perhaps a different formula?

 

[OaklandJim]

It's difficult to tell what you need with your post. I suggest that you post a link to your file (e.g. with DropBox) so we have some actual data to work with? Hopefully no data is confidential.

Then try again to explain the need. Maybe it'll be more clear.