Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default show the last value in a list

I have a very basic columnt list which I populate with figures, it should be
simple I know, but I can't seem to find something which shows the last value
in the list.
e.g. The list has a max of 52 entries, which I enter weight figures into,
but would like to display the last value entered in another cell, which
ALWAYS shows that last entered figure.
Please help !
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default show the last value in a list

see other post.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"IvanM" wrote in message
...
I have a very basic columnt list which I populate with figures, it should

be
simple I know, but I can't seem to find something which shows the last

value
in the list.
e.g. The list has a max of 52 entries, which I enter weight figures into,
but would like to display the last value entered in another cell, which
ALWAYS shows that last entered figure.
Please help !



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced filter and a list Epinn New Users to Excel 14 September 20th 06 02:11 AM
Using IF formula to show what text is in the cell from ddown list Clark Excel Worksheet Functions 4 May 25th 06 08:19 AM
Setting for Excel automatically show count result in list ? Andrew Tan Excel Worksheet Functions 1 March 20th 06 02:37 AM
Compare List and Show Mismatched Phillycheese5 Excel Worksheet Functions 3 June 22nd 05 05:25 PM
On my data menu, my list command does not show pebbles2005 Excel Discussion (Misc queries) 1 March 28th 05 10:49 PM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"