Results 1 to 8 of 8

Index/Match to return values to compare

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Index/Match to return values to compare

    Help please -using excel 2010 I cannot work out how to put in place the following.

    I want to enter values for various investments on different dates I.e. each column to have a date heading and each row / record to have a fund and the value for the column date. I then want to select 2 columns to compare

    So my table would be something like this:

    Investment. 1 jan 2012. 1 feb 2002. 1 mar 2002

    Inv 1. 10,000. 12,000. 13,000
    Inv 2. 1,000. 1,500. 2,000
    Inv 3. 500. 600. 700


    With the above I then want to select say 1 jan and 1 mar and work out the % change say in a new table or a separate worksheet. Or I may want to select 1 feb and 1 mar. How would I do this?
    Last edited by Iptgfs; 03-01-2013 at 02:33 AM.

Thread Information

Users Browsing this Thread

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

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