+ Reply to Thread
Results 1 to 7 of 7

To find Weekly High and Low for the company

  1. #1
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    129

    To find Weekly High and Low for the company

    Hi,
    I have data in column A to Column E in which name of the company,High price,Low price,date and week is mentioned.
    What my requirement is that if I type in Cell H1 name of the company then in H3 I should get high price of that company for that particular week and in H4 I should get Low Price of that company.
    For better understanding I have attached excel sheet.

    Thanks in advance

    Goodboy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,029

    Re: To find Weekly High and Low for the company

    Try this pivot table
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    129

    Re: To find Weekly High and Low for the company

    Thanks for the answer. But i was actually looking for formulas

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,029

    Re: To find Weekly High and Low for the company

    Then use the 'sumproduct' or the 'sumifs' formula

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,029

    Re: To find Weekly High and Low for the company

    =sumproduct((range=expectedvalue)* (range=expectedvalue)* (range=expectedvalue)* (range=expectedvalue))

    Something like this.

  6. #6
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    129

    Re: To find Weekly High and Low for the company

    Still can't get as mentioned can somebody help with formulas

  7. #7
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: To find Weekly High and Low for the company

    Hi goodboy, try the array formulas (ctrl+shift+enter) below:

    Formula: copy to clipboard
    Please Login or Register  to view this content.




    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search on company name to auto input company address
    By jamie.c in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2009, 12:38 PM
  2. Replies: 3
    Last Post: 01-27-2006, 06:30 PM
  3. Find all roots of a high-order equation
    By Pan in forum Excel General
    Replies: 1
    Last Post: 10-28-2005, 10:05 AM
  4. any way to find out the historical high of mailbox size
    By PinkCrib in forum Excel General
    Replies: 1
    Last Post: 05-27-2005, 12:05 PM
  5. [SOLVED] Find High Score
    By Lee in forum Excel General
    Replies: 0
    Last Post: 04-16-2005, 02:06 PM

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