+ Reply to Thread
Results 1 to 2 of 2

Formula to get last used cell

  1. 05-17-2016, 09:33 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to get last used cell

    Hello:

    Please refer to attached file.
    I have data as shown in Sheet1.
    I need a formula in Sheet2, cell G20 to give teh address of the last used cell in Column A Sheet1.
    In this example it needs to be G20 will be A470

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-17-2016, 10:29 AM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula to get last used cell

    Try this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to return Blank cell if referenced cell has no entries, if not use formula
    By stpeter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2016, 01:41 PM
  2. VBA to enter formula in cell not calculating...showing formula in cell
    By kmlloyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2015, 06:42 PM
  3. [SOLVED] Enter formula result from one cell into a COUNTIF formula in another cell. Help please!
    By gregrach in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 11:23 AM
  4. Auto-fill a cell based on a drop down selection in one cell & a formula in another cell
    By Deena C in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  5. [SOLVED] Retaining formula cell references when copying a formula to a different cell
    By FrankParisi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2013, 07:05 AM
  6. populate cell with formula referenced from array, insert adjacent cell value into formula
    By globalfuture in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 08:34 AM
  7. Change Cell Font Color if Cell Contains Formula Referencing Another Cell
    By wilcox.patrick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 10:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1