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