Results 1 to 10 of 16

Thread: Reference A Cell Conditionally Using ADDRESS And INDIRECT Functions

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-04-2013, 08:53 AM #7
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by mahmoud-lee View Post
    I know this is good, but you can combine ( row & column ) in same formula
    Oh, I think I understand what you want now... if I am right, this won't be too flexible (good for only one text cell) as it requires an absolute reference to the cell with the text. Give this formula a try and see if it does what you want...

    =SUBSTITUTE(MID($A$1,ROW(A1)+COLUMN(A1)-1,1)," ","x")
    Last edited by Rick Rothstein; 06-04-2013 at 08:56 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Need a way to conditionally format a cell based on an adjacent cells value.
    By Orestees in forum Excel Help
    Replies: 2
    Last Post: 01-24-2013, 09:03 PM
  2. Indirect Address Column Formula help needed
    By trankim in forum Excel Help
    Replies: 4
    Last Post: 10-13-2012, 02:15 PM
  3. Change in One Cell that Prompts Email to Address in Adjacent Cell
    By jtroi89 in forum Excel Help
    Replies: 1
    Last Post: 08-21-2012, 07:36 PM
  4. Get last Filled Cell address in a Range.
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 3
    Last Post: 03-24-2012, 01:08 AM
  5. Excel Macro Functions (GET.CELL)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 05-17-2011, 08:56 AM

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