Consulting

Results 1 to 7 of 7

Thread: Last Occurence of last month Transaction using Index sumproduct

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-16-2017, 08:53 AM #1
    tlchan
    tlchan is offline
    VBAX Contributor
    Joined
    Sep 2007
    Posts
    119
    Location

    Last Occurence of last month Transaction using Index sumproduct

    Hi,

    I try to obtain the last transaction balance of a selected currency in sheet2 from a daily transaction database in sheet1 using combination of INDEX SUMPRODUCTS and MAX but is not working.

    Date in sheet2 B2 for reporting month (March 17) and I require to obtain last occurence of the respective currency in previous month (Feb 17) from sheet 1

    sample file attached
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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