There are times when it is best to use formulas. For example, at the end of the year, you could copy the data from each monthly tab into a combined yearly tab, and then sort high to low. However, you might want to do a lot more analyzing on the data, and formulas would be the way to go.
Try using defined names. Define Jan!T1:T99 as AREA
The formula then becomes
=LARGE(AREA,1)
=LARGE(AREA,2)
etc
This approach can reduce formula errors that occur when we're adding and deleting rows, and changing the data, which is what I suspected caused the area in Line 3 to change from T1:T99 to T1:T76
Lots of complexities using excel.
Ammie's right ... keep it as simple as possible ... just like this stupid game we keep playing
- Forums
- ASX - Short Term Trading
- Short Term Trading Weekend Lounge: 12 - 14 Feb
Short Term Trading Weekend Lounge: 12 - 14 Feb, page-59
-
-
- There are more pages in this discussion • 9 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)