Call Bottom Cell
I want to be able to call the bottom number in a set of data that is ever expanding. I don't really know how else to describe it, so I will give an example.
Say I have:
3
6
4
I would want to be able to call 4, but then if I had:
3
6
4
5
I would want to be able to call 5, and so on. Is there any simple way of doing this? I basically want the maximum cell name, and the corresponding data inside of it. Thanks!
Last edited by Tman21901; 02-11-2010 at 11:37 PM.
Assuming your numbers are in column a use this-->
=LOOKUP(9.9999999999999E+307,A:A)
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Awesome thanks for the super quick reply! It does exactly what I was looking for. However, is there anyway you could explain it a little, just so I could understand what it is doing? Thanks again!
9.9999999999999E+307 is the biggest number once it does not find it it will use the last number it finds
Gotcha! Again thanks for such a fast response!
Further to this, how can I refer to the last x number of entries in a list. For example I would like to find the average of the last 3 entries in a list, where the list grows over time? Thanks very much, I have been working on a solution for 6 months now, but I just can't do it!: confused:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks