Forum Discussion
Lookup Issue
I have a workbook with different worksheets for each stock that I own that keeps a daily record of the price to show how it does each day of the year. At the bottom of each sheet is a formula that ta...
Any chance you can submit a sample file describing what you need.
Seems like putting a formula at the top of each sheet to give an average for the year and the latest price (by doing a SUMIFS that references the MAX of the date column) would be a simpler approach.
Would need to see how your file is laid out to give best advice
Thanks
Wyn
MVP
Seems like putting a formula at the top of each sheet to give an average for the year and the latest price (by doing a SUMIFS that references the MAX of the date column) would be a simpler approach.
Would need to see how your file is laid out to give best advice
Thanks
Wyn
MVP
