LARGE in WPS on Windows: Introduction

LARGE in WPS Spreadsheet on Windows returns the k-th largest value in a data set for ranking and analysis; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

The LARGE function is a built-in formula in WPS Spreadsheet on Windows. It returns the k-th largest value from a numeric range and is useful for score ranking, sales analysis, and other data review tasks.

Core capabilities include:

Enter LARGE(array,k) to return the k-th largest value.
View syntax prompts while typing the function.
Combine the function with cross-sheet references or nested formulas so results update when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account services
Other	You need to open WPS Spreadsheet files and have permission to edit cell formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Verify after installation	Open WPS Office, start Spreadsheet, and type `=LARGE(` in a cell to confirm that the formula entry point and syntax prompt are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports `LARGE(array,k)` in WPS Spreadsheet to return the k-th largest value, and can be used with cross-sheet references and nested formulas for data analysis.	Excel provides `LARGE(array, k)` to return the k-th largest value in a data set.	Google Sheets provides `LARGE(data, n)` to return the nth largest element from a data set.	Notion formulas support properties, operators, and many functions for database calculations, but the official formula reference does not present a spreadsheet-style `LARGE` function with the same syntax.	Acrobat official guidance focuses on PDF form data collection, export, and spreadsheet output, rather than spreadsheet functions such as `LARGE`.
WPS Advantages	Advantage: You can calculate the k-th largest value directly in WPS Spreadsheet. Distinct: syntax prompts, cross-sheet references, and nested formulas support continuous spreadsheet analysis.	Compared with WPS: Excel offers a directly comparable `LARGE` function and is commonly used in Microsoft-based spreadsheet workflows.	Compared with WPS: Google Sheets also offers a directly comparable `LARGE` function, with a stronger browser-based collaboration focus.	Compared with WPS: Notion is centered on database property formulas instead of traditional cell-by-cell spreadsheet function editing.	Compared with WPS: Adobe focuses on PDF workflows and data export rather than built-in spreadsheet ranking functions.
Official Source	—	LARGE function	LARGE	Formula syntax and functions	Collect and manage PDF form data

Overall Conclusion: If your main task is ranking values and analyzing spreadsheet data on Windows, WPS provides a direct LARGE function workflow inside Spreadsheet. Microsoft Excel and Google Sheets offer similar function coverage, while Notion and Adobe focus on different product models and use cases.

Use Cases

No.	Scenario	Suitable For	Main Need	How LARGE Helps
1	Score ranking	Teachers and trainers	Find the 1st, 2nd, or 3rd highest score quickly	Use LARGE to return the score for a selected rank
2	Sales analysis	Sales and operations teams	Identify top values from a large data range	Use LARGE on the sales column to extract key values
3	Multi-sheet analysis	Finance and analysts	Data is spread across worksheets	Combine cross-sheet references with LARGE for calculation
4	Dynamic reports	Managers	Ranking results need to refresh when data changes	LARGE recalculates automatically after source updates
5	Formula combinations	Advanced spreadsheet users	A single function is not enough for complex analysis	Nest LARGE with other formulas for broader calculations

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Basic use of the LARGE function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More advanced value-added features	Shown in product experience where applicable	Includes additional advanced features and services

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday formula work and basic spreadsheet editing	Free	Basic LARGE function usage is enough for common ranking and analysis tasks
Long-term work that also needs more advanced office features	WPS Premium	Suitable when you also need more advanced features, cloud space, or added services

WPS membership center: Subscribe now