Returning the Max from a large amount of data and multiple criteria

[patteb]

is it possible to use a formula that will return the below from a large amount of data when given a date range?
i need to know what Assigned ID performed the best over the date period, what was their total volume for that date period and the location.

i have been looking for formuals that use Sum with Max but can find anything that suits .

the Assigned ID can be duplicated within the date period so i need to be able to sum all that are the same for that peiod and retun the max.

the retuns needed is as follows:
Assigned ID Total Volume Location

the coulms in the data are:
A - Assigned ID
B - Volume
C - Location
D - Language
E - Date Range

Eg:
Assigned ID Volume Location Language Date Range
261654 152 Dublin English Jan 01 - 15

 

[SteveO59L]

have a look at Pivot Tables

 

[golfboy7]

Hey patteb,

I agree with Steve059L's suggestion of using Pivot table(s) for your need since what you seem to be asking for is most easily accomplished in that way.

If you're not familiar with Pivot tables, doing a google search on the subject should yield some beginner tutorials. If you're not having any luck in that arena, return here and I'm sure we'll be happy to assist further.