Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Matching

Matching

ResolvedVersion 2003

Mon 30 Mar 2009, 11:56 Delegate James said...

James has attended:
Excel Advanced course

Matching

I have a list of daily prices (for various stocks) over a period of 20 years or so and want to pull in the first and last prices for each year. The prices are given on trading days so it is invariably the case that 01/01/19** and 31/12/19** do not exist in the list. Ideally i would like to pull these in a single column one on top of each other in their correct order.
Thanks

Tue 31 Mar 2009, 20:25 Trainer Amanda said...

RE: matching

Hello James

Thank you for your question.

Please refer to my reply to your original post:
https://www.stl-training.co.uk/post-21394-match.html #21457

Thanks.

Kind regards
Amanda

Thu 9 Apr 2009: Automatically marked as resolved.

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Matching

Matching

RE: matching

Excel articles

Excel tip:

Adding up rows or columns without seeing formulas