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 » Excel 2003
Excel 2003
Resolved · Low Priority · Version 2003
Thu 11 Dec 2008, 16:21Delegate Nigel said...
Nigel has attended:
Excel Intermediate course
Excel 2003
How to determine the maximum value in a list?
Thu 11 Dec 2008, 16:51Trainer Amanda said...
RE: Excel 2003
Hello Nigel
Thank you for your question and welcome to the forum.
If you wish to determine the highest/largest/maximum value within a column in a list of data, you can do the following:
1. Turn on AutoFilter (Data - Filter - AutoFilter).
2. Using the dropdown arrow next to the column you wish to find the maximum value in, select Top 10.
3. Change settings to Top, 1 and Item; then click OK.
This will give you the row that contains the largest/maximum value.
4. Go to Data - Filter - Show All to restore the whole list.
Kind regards
Amanda
Thu 18 Dec 2008: Automatically marked as resolved.
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:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |
