Hi everyone,

I was wondering if there is a formula to calculate the MAX number in a range but limit the search with certain identifiers.

For example; lets say the list looks like this:

3101

3102

3103

3201

3202

3203

3301

3302

3303

I want to select this range but only find the MAX number between say 3100-3199, and then do the same for 3200-3299 and 3300-3399 etc.

Edit: OR "MAX number from all numbers starting with 31,32,33 etc"

Is this possible? I tried googling but couldn't find anything for this specific formula.

Thanks in advance

-Adam

## Bookmarks