Find last value in column?

[domgilberto]

I am using a basic formula to calculate percentage gain but I am specify a particular cell in the equation. This provoked me into thinking if it were possible to have my formula look up the entire column (3000 rows) and find the last inputed figure within the equation?

The formula I am using is simple: =(AN94-AN6)/AN6

As you can see AN94 in this case works. AN6 is static but AN94 could be a much larger number or lower row number. Instead of my having to find this particular row, I just want to know if this is the last piece of data in the worksheet (i.e. nothing comes after AN94 in this case so use AN94).

Thanks!

[AlKey]

This will give you the last value in a column AN

=LOOKUP(100^100,AN:AN)

[Pepe Le Mokko]

http://www.xldynamic.com/source/xld.LastValue.html

[AlKey]

Thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

[domgilberto]

Thanks for both responses! One thing I love about this site is how quickly people respond! Thank you!

Just out of curiosity, where can I see a list of all of excels equality symbols (i.e <> ^ >= <= etc). Just wondering what ^ means

[AlKey]

"^" called caret and it is used to create a very large number. For example, formula =2^5 in excel will result in 32. When used in the context of this formula, the LOOKUP function will search for this very large number and if not found, the formula will return to the last row, as it would assume that the last row would carry the largest number.