Show last value in cell
hello,
i have a sheet with name "Entry" and a sheet with "Total"
in sheet "Entry"
i have data in D10:D500 like d10=1, d11=3, d12=12, d13=27.........
i want to result=last value of Column "D" on sheet "Total"
e.g last value in D13=27 then the result should be 27 on sheet "Total"
thanx
here, try this:
Formula:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Thanx Zbor
works perfect. Added repu to you +1
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks