+ Reply to Thread
Results 1 to 1 of 1

Unexpected (to me) ways to use INDIRECT

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Nebraska, USA
    MS-Off Ver
    Excel for Win 2016, Excel for Mac 2016
    Posts
    13

    Unexpected (to me) ways to use INDIRECT

    In the upload, I compare more conventional ways of using INDIRECT with a way that I bumbled onto: I nested the function ROW() in INDIRECT, and found some (possibly) novel results.

    Also in the upload, just for kicks & giggles, I nest several instances of INDIRECT to get a kind of recursion.

    None of this is important, probably, just thought that I'd share.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 3 Ways Look up
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-19-2016, 05:36 AM
  2. How many ways can a routine end?
    By Oppressed1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2015, 12:01 PM
  3. To many ways... but it is fun
    By vbaorvb in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-03-2014, 01:17 PM
  4. Two ways to search
    By 1000xx in forum Excel General
    Replies: 0
    Last Post: 05-21-2011, 04:48 AM
  5. Ways of Tracking Changes
    By yuzi in forum Excel General
    Replies: 21
    Last Post: 03-25-2011, 09:42 PM
  6. There are many different ways - pick one!
    By Blake 7 in forum The Water Cooler
    Replies: 1
    Last Post: 02-17-2011, 02:25 AM
  7. ways to run a macro
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2005, 04:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1