98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft/access/training/courses - Subtotals
microsoft/access/training/courses - Subtotals
Resolved · Low Priority · Version Standard
Wed 7 Mar 2007, 13:08Delegate Andrea said...
Andrea has attended:
Excel Advanced course
Subtotals
I am using subtotals with the function "Max", which displays the highest value in an array. I would also like to display the product the value refers to, rather than just the value itself.
Can anybody help?
Mon 12 Mar 2007, 17:01Trainer Richard said...
RE: subtotals
hi Andrea
I have emailed you a possible solution to your gmail account.
Basically you can do it by using match & index, similar to Vlookup. The different is that Vlookup only works one way, whereas the index and match can be assembled to your requirements.
Take a look at the attachment and see if you can see how I did it. IF so, apply it to your situation.
Richard
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
