+ Reply to Thread
Results 1 to 5 of 5

Fomula to Calculate Multiple Columns with TIED Values

  1. #1
    Registered User
    Join Date
    05-18-2008
    Location
    Perth, Australia
    Posts
    19

    Fomula to Calculate Multiple Columns with TIED Values

    Hi All,

    I have attached a sample spreadsheet of what I am trying to achieve. I want to be able to get the lowest value of column F to compare with the highest value of column D (For each Row) and have this output the data in column H using the associated column A data and column I to have the associated column C data. Is this possible?

    If so, how can this be done?

    If not, is this something that would require Macros??? Or something along those lines?

    Sample 1 shows the data output that I am after and sample 2 shows the values that I want in these columns.
    Attached Files Attached Files

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    There might be a formula that gives you what you want, but a pivot table can also give you the results. Good thing about the pivot is that (once refreshed) it will display the new results as you insert more data.

    See attached
    Attached Files Attached Files
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    05-18-2008
    Location
    Perth, Australia
    Posts
    19
    Can you please provide me with further information or an example on how this can be done? I haven't worked with pivot tables before either.

  4. #4
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Hi, In the previous post I attached a sheet that contains the pivot table with the results.

    Pivot tables are a have a lot of functions and details that I wouldnt be able to describe to you in a post. There is a lot of documentation on the web about pivot tables.

    Try these links:
    http://www.cpearson.com/excel/pivots.htm
    http://www.lacher.com/toc/tutpiv.htm

  5. #5
    Registered User
    Join Date
    05-18-2008
    Location
    Perth, Australia
    Posts
    19
    Thanks for that. This looks ok but the thing is, I need for the original formula to stay in place as this is the output data and formula that has been required to get the details up to this stage.

+ Reply to Thread

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