-2

I have a row of values in a range and need to subtract the value in the last cell in the row from the value of the first cell of the row. The challenge is that the last cell location is unknown, so the formula needs to be general.

1
  • Welcome to SuperUser. Please take a minute to read through the Help Center to learn how this site works and how to improve your question with details of what you have researched and attempted to resolve this issue on your own. Dec 15, 2014 at 19:25

1 Answer 1

2

This formula finds the last number in the range A2:Z2, adjust as required:

=LOOKUP(9.99E+307,A2:Z2)

9.99E+307 is [almost] the largest number that excel can handle, when the lookup value is so large that it won't be found in the range then that results in the formula finding the last number in that range

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .