Short Term Trading Weekend Lounge: 12 - 14 Feb, page-59

  1. 6,696 Posts.
    lightbulb Created with Sketch. 1582
    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

    https://hotcopper.com.au/data/attachments/2905/2905866-b316a1fbef2eb045d396ed04ea7d1549.jpg

    Lots of complexities using excel.

    Ammie's right ... keep it as simple as possible ... just like this stupid game we keep playing tongue.png
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.