microsoft/access/training/courses - Subtotals

Resolved · Low Priority · Version Standard

Wed 7 Mar 2007, 13:08 Delegate 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:01 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Remove spaces in a table

If 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

View all Access hints and tips