LARGE in WPS on Windows: Introduction

LARGE in WPS Spreadsheet on Windows returns the k-th largest value in a dataset; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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 spreadsheet function in WPS Office for Windows. It returns the k-th largest value from a dataset and is useful for score ranking, sales analysis, range-based statistics, and dynamic reports.

Core capabilities include:

Return a value by rank, such as the largest, second-largest, or nth-largest result.
Accept flexible parameters with cell ranges and rank values.
Support cross-sheet references and nested formulas.
Recalculate automatically when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related 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
Post-install check	Launch WPS Office, open Spreadsheet, and type `=LARGE(` in a cell to confirm that the function entry and editing flow are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, `LARGE(array,k)` returns the k-th largest value in a dataset and supports formula prompts, cross-sheet references, and nested calculations.	Excel provides the LARGE function to return the k-th largest value in a data set and documents error cases when the array is empty or k is out of range.	Google Sheets provides `LARGE(data, n)` to return the nth largest element from a dataset, using an array or range as input.	Notion formulas work with database properties, built-ins, and functions for calculations, but the official help page does not describe a direct spreadsheet-style LARGE function.	Adobe Acrobat focuses on PDF form data collection, export, and conversion, and its official documentation does not describe spreadsheet ranking functions.
WPS Advantages	Advantage: Direct cell-based formula editing for ranking results in WPS Spreadsheet; Distinct: fits spreadsheet workflows that combine references, nested formulas, and recalculation in one sheet.	Compared with WPS: Excel offers a similar LARGE function and places more emphasis on syntax rules and error conditions in its documentation.	Compared with WPS: Google Sheets also supports LARGE, with a stronger focus on browser-based spreadsheet workflows.	Compared with WPS: Notion is centered on database property formulas rather than cell-by-cell spreadsheet function editing.	Compared with WPS: Adobe’s related workflows focus on PDF data handling instead of spreadsheet formula calculation.
Official Source	—	LARGE function	LARGE	Intro to formulas	Collect and manage PDF form data

Overall Conclusion
WPS, Microsoft Excel, and Google Sheets all support LARGE for rank-based value extraction in spreadsheets. For Windows users who want direct cell editing, cross-sheet references, and recalculation in a familiar spreadsheet workflow, WPS provides a practical path. Notion and Adobe are better aligned with database and PDF workflows.

Use Cases

No.	Scenario	Suitable Users	Main Need	How LARGE Helps
1	Score ranking	Teachers and school staff	Quickly identify top scores in a class	Use LARGE to return the 1st, 2nd, 3rd, or nth score
2	Sales analysis	Sales and operations teams	Extract high-value results from large datasets	Use LARGE to pull key sales values for review
3	Dynamic reporting	Finance and analysis teams	Avoid manual re-sorting after data updates	LARGE updates results automatically when data changes
4	Combined formulas	Advanced spreadsheet users	Build more complex analysis flows	Nest LARGE with other functions for broader calculations

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of the LARGE function	✅ Available	✅ Available
Standard spreadsheet formula editing	✅ Available	✅ Available
Additional PDF, template, and extended office benefits	Available within the free offering shown on the pricing page	Includes broader advanced benefits and higher allowances shown on the pricing page

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet work, learning, and basic ranking analysis	Free	The LARGE function itself is available without membership for standard data work
Users who also need broader advanced office benefits	WPS Premium	Suitable when you need more PDF, template, or extended office capabilities

WPS membership center: Subscribe now