LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Arlen
 
Posts: n/a
Default Grabbing the last Non-empty cell in a range

Howdy all y'all. I have a spreadsheet that totals the daily production,
keeps a running total of production everyday, and also shows the average
daily production. The first of these is totaled at the bottom... but the
second two should simply reflect the values of the very last cell with data
in it.

How do I set a cell to display the number in the last non-blank cell of a
certain range of cells? I don't even know how to word this question to the
assistant, Clippy.

Thank you very much for the predicted help.

Arlen
 
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
Cell range in Excel Joe Sadusky Excel Discussion (Misc queries) 1 January 16th 05 01:14 AM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 01:12 AM
View and Cell Sum Range Dewayne Excel Discussion (Misc queries) 4 December 29th 04 03:23 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
Empty Cells, Spaces, Cond Format? Ken Excel Discussion (Misc queries) 3 December 4th 04 04:47 PM


All times are GMT +1. The time now is 07:17 AM.

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

About Us

"It's about Microsoft Excel"