# Google Sheets LARGE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/large-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The LARGE function returns the k-th largest value in a dataset, allowing users to identify high-ranking numbers easily. ``` LARGE(data, n) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the LARGE you need in plain EnglishGenerate Formula ## Parameters **`data`**:\ The range of cells or array from which you want to find the largest value(s). **`n`**:\ The position (from the largest) in the sorted list of values to return. For example, `1` returns the largest value, `2` returns the second largest, and so on. ## What is a LARGE Function? The *LARGE* function in Google Sheets is a useful tool that allows you to find the nth largest value in a dataset. This function is particularly helpful when you want to analyze data by identifying top performers, such as the highest sales figures, scores, or any numerical data. In simpler terms, LARGE helps you extract significant values from a set of numbers, making it easier to analyze and interpret your data. ## A Practical Example Imagine you are tracking the sales performance of different products in a store: ### Sales Data Table: | ProductID | ProductName | Sales | | - | - | - | | 101 | Widget A | 500 | | 102 | Widget B | 750 | | 103 | Widget C | 300 | | 104 | Widget D | 900 | | 105 | Widget E | 650 | You want to find out the top 3 sales figures from this data. ## LARGE Formula To achieve this, you would use the LARGE function as follows: ``` =LARGE(Sales!C:C, 1) // For the highest sales =LARGE(Sales!C:C, 2) // For the second highest sales =LARGE(Sales!C:C, 3) // For the third highest sales ``` In these formulas: - `Sales!C:C` is the range where the function will look for the Sales figures. - The second argument (1, 2, or 3) specifies which largest value you want to retrieve. ## Result of the Formula When you apply the LARGE formula to the Sales Data Table, the output would look like this: | Rank | Sales | | - | - | | 1 | 900 | | 2 | 750 | | 3 | 650 | This table shows the top three sales figures from the dataset. ## Why Use LARGE? LARGE is beneficial because it simplifies the process of identifying significant values in a dataset. It allows you to quickly find top performers without having to sort or filter your data manually. This can save time and enhance your data analysis capabilities. ## Key Takeaways: - **LARGE**: A function that retrieves the nth largest value from a dataset. - **Easy to Use**: Simplifies the process of finding top values without complex calculations. - **Versatile**: Can be applied to various datasets, making it suitable for different analytical needs. - **Common Use Cases**: Ideal for performance tracking, ranking, and any scenario where identifying significant values is necessary. LARGE is an essential function for anyone working with numerical data in Google Sheets, providing a straightforward way to enhance data analysis and reporting capabilities. Happy spreadsheeting! ## Example use case You have a sales report in Column A with sales figures. To identify the top three sales performances, use the LARGE formula to extract the highest values. This helps in recognizing top performers and strategizing for future sales initiatives efficiently. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-in-google-sheets) - [How To Unhide Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-rows-in-google-sheets) - [How To Unprotect Google Sheets](https://betteranalyst.com/google-sheets/how-to-unprotect-google-sheets) - [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets) - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.