Results 1 to 3 of 3

XIRR Formula That Recognizes Change of Group

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2023
    Location
    Texas, USA
    MS-Off Ver
    Excel for Mac 16.68
    Posts
    3

    XIRR Formula That Recognizes Change of Group

    Hello,

    I have a series of investments that I'm trying to quickly calculate IRRs for. I'm wondering if there's a way to write a formula that will calculate based on a change in Column A.

    I need it to calculate XIRR for all 'A' values, then 'B', then 'C', etc. Right now I have to do this manually for hundreds of lines.

    A 1/1/20 -300
    A 2/3/21 -400
    A 12/31/22 500
    B 1/1/20 -300
    B 2/3/21 -400
    B 3/5/21 -500
    B 6/20/21 -700
    B 1/15/22 -50
    B 6/15/22 -150
    B 12/31/22 2000
    C 1/1/20 -300
    C 12/31/22 700
    D 1/1/20 -300
    D 3/5/21 -60
    D 12/31/22 1500
    E 1/1/20 -300
    E 2/3/21 -800
    E 3/5/21 -900
    E 6/20/21 -150
    E 1/15/22 -200
    E 6/15/22 -70
    E 8/3/22 -200
    E 12/31/22 800
    F 1/1/20 -300
    F 12/31/22 500

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula that recognizes another cell
    By LLGMK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2014, 12:31 AM
  2. Formula that recognizes change in field
    By mttlltt75 in forum Excel General
    Replies: 1
    Last Post: 10-01-2008, 02:28 PM
  3. [SOLVED] If formula that recognizes #N/A
    By Box815 in forum Excel General
    Replies: 2
    Last Post: 03-17-2006, 11:30 AM
  4. Formula that recognizes duplicates
    By RagDyer in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-06-2005, 07:05 AM
  5. Formula that recognizes duplicates
    By Courtneyf04 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. Formula that recognizes duplicates
    By Courtneyf04 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Formula that recognizes duplicates
    By Courtneyf04 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

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