Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EXCEL - Sorting Column Data for Hyetograph
As Drew08 mentioned, you can use Index to do the sorting that you wanted. The data that you're showing has 60 points, so you can do a brute force like this. The high-to-low sorted data points will be a range that I call [Data]. Using the simple A1:A100 example, [Data] is the range A1:A100...- zuludogm
- Post #13
- Forum: -Engineering spreadsheets
