Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 1st 06, 09:08 AM posted to microsoft.public.excel.misc
kevcar40
 
Posts: n/a
Default find last none empty cell

Hi
i have a worksheet that allows the user to enter data over a range
C27 : Z27
What i want to do is check the range and return the last cell that
contains a value
i have tried several formulas but am getting lost
this formula below is the closest i can get to resolving the problem

=ADDRESS(ROW(A5),MATCH(<" ",A5:E5))


can anyone help please

thanks

kevin


  #2   Report Post  
Old March 1st 06, 09:25 AM posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default find last none empty cell

=ADDRESS(ROW(A5),MAX(IF(ISBLANK(C5:Z5),0,COLUMN(C5 :Z5))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kevcar40" wrote in message
oups.com...
Hi
i have a worksheet that allows the user to enter data over a range
C27 : Z27
What i want to do is check the range and return the last cell that
contains a value
i have tried several formulas but am getting lost
this formula below is the closest i can get to resolving the problem

=ADDRESS(ROW(A5),MATCH(<" ",A5:E5))


can anyone help please

thanks

kevin



  #3   Report Post  
Old March 1st 06, 11:59 AM posted to microsoft.public.excel.misc
kevcar40
 
Posts: n/a
Default find last none empty cell

thank you
works a treat

kevin

  #4   Report Post  
Old March 1st 06, 11:59 AM posted to microsoft.public.excel.misc
kevcar40
 
Posts: n/a
Default find last none empty cell

thank you
works a treat

kevin



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
Is there a way to go to next empty cell in a formula Hopeful Exel User Excel Worksheet Functions 0 April 19th 05 10:53 PM
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
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
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017