# To find Weekly High and Low for the company

1. ## 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.

Goodboy

2. ## Re: To find Weekly High and Low for the company

Try this pivot table

3. ## Re: To find Weekly High and Low for the company

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

4. ## Re: To find Weekly High and Low for the company

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

5. ## Re: To find Weekly High and Low for the company

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

Something like this.

6. ## Re: To find Weekly High and Low for the company

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

7. ## Re: To find Weekly High and Low for the company

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

Formula:
`Please Login or Register  to view this content.`

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you

Alvin

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

#### 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