LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default Can I find the last value in a column of cells?

Hi - I have a column of cells that is fixed length but the entries within it
are not fixed, some columns might have more or less entries than another
column. I want to find the bottom entry in the list, regardless of what row
that entry is in and return the value of that entry please?

eg, all columns have 12 cells, col A has 3 entries, col B has 1, col C has 6
etc. The entries are NOT in value order and cannot be sorted but each column
is independant of the others, if that helps.

TIA
Chris

 
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
Find the first & subsequent cells to contain text in a column & re M Excel Discussion (Misc queries) 28 July 26th 09 07:04 PM
How to find duplicate cells in Column a & retrieve column B ghost Excel Discussion (Misc queries) 2 February 22nd 09 05:39 PM
How can find match of one cell from a column of cells? mat Excel Discussion (Misc queries) 1 October 26th 06 04:59 PM
How to find repetition of data in cells in a column? Joseph T J Excel Discussion (Misc queries) 1 February 15th 06 06:12 PM
Can Excel find & sort one item in all the cells in a column? AHSinVT New Users to Excel 3 January 22nd 06 10:24 PM


All times are GMT +1. The time now is 11:14 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"