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 Excel Training and help » Getting a satistical range
Getting a satistical range
Resolved · Low Priority · Version 2003
Fri 7 May 2010, 08:24Delegate Dee said...
Dee has attended:
Excel Advanced course
Excel Intermediate course
Getting a satistical range
Is there a way to find a range (lowest and highest numbers in a group) when the cells are not adjacent? I've tried working with a formula using RANGE, but it keeps coming up with #VALUE.
Can it be done?
Cheers,
Dee
Fri 7 May 2010, 16:24Trainer Nafeesa said...
RE: Getting a satistical range
Hi Dee,
Thank you for your question regarding highest & lowest numbers in a range of data that are non-adjacent.
The functions you would be looking to use would be the 'Min' or 'Max' function.
...so, for example, if you have data in the range A1:A10 and another set of data in the range D1:D10 and now from within these two ranges you want to find the highest value, the formula you would need to create would look something like:
=max(A1:A10,D1:D10) this would present the highest value.
Replace the 'Max' function with 'Min' to determine the lowest value.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require any further assistance, please reply to this post.
Have a lovely weekend.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
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. |
Excel tip:Seeing named ranges as part of the zoomIf you have large areas of named ranges this works better. |
