+ Reply to Thread
Results 1 to 1 of 1

XIRR modification to ignore some columns

  1. 03-08-2023, 04:04 AM #1
    grcshekar
    grcshekar is offline
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    364

    XIRR modification to ignore some columns

    Hello.

    Attached is the sample sheet. I want to modify formula in Column O to ignore Columns B,C and M,N and get same results. Of course

    Help please
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating XIRR on Non-Contiguous Rows and Columns based on Criteria
    By e4excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-22-2021, 09:56 AM
  2. [SOLVED] XIRR - Keeping First Cell Blank in Some Columns
    By ba3uoqtcp947t5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2020, 02:58 AM
  3. [SOLVED] XIRR Help - Ignore Cells without Values
    By cchase22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2019, 09:25 AM
  4. Help in calculating XIRR for entries from different columns
    By rishiambekar in forum Excel General
    Replies: 14
    Last Post: 09-13-2019, 12:02 AM
  5. [SOLVED] VBA to Copy Columns Using Headers but Ignore Columns without Data
    By phelbin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2018, 04:41 PM
  6. [SOLVED] .Find Help - Search only in specific columns (or ignore other columns)?
    By NewYears1978 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 11:32 AM
  7. [SOLVED] Skip columns from XIRR function
    By Bedazelled in forum Excel General
    Replies: 0
    Last Post: 04-26-2006, 03:15 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1