Query : In offset function i am not able to subtract two values

[Nouman381]

Respected Experts,

My query is that i am going to use Offset function and i want to subtract the last two values,
Since i have to add a column daily to right so i am using offset and count function.

It would be great help if you can guide on how to modify this formula to get the desired result every day.

Looking forward for the kind replies.

Best Regards.

 

[Nouman381]

Respected Experts,

My query is that i am going to use Offset function and i want to subtract the last two values,
Since i have to add a column daily to right so i am using offset and count function.

It would be great help if you can guide on how to modify this formula to get the desired result every day.

Looking forward for the kind replies.

Best Regards.

This is the issue that i am getting the unwanted result using the above formula =SUM((OFFSET(C6,0,COUNTA(D6:AB6),1,-2)))

 

[Fluff]

How about

=LOOKUP(2,1/(D6:O6<>""),D6:O6-C6:N6)

 

[Nouman381]

How about

=LOOKUP(2,1/(D6:O6<>""),D6:O6-C6:N6)

Much happy to get this kind help, yes it served the purpose exactly as i desired.
Stay blessed. Thank you !

 

[Fluff]

You're welcome & thanks for the feedback.