4

How can the text value be returned from the Large() function?

edit

• sed

asked 2023-01-31 11:00:00 +0000

plato
56 ●5 ●5

edit retag flag offensive close merge delete

add a comment

3

answered 2023-03-31 11:00:00 +0000

lakamha
21 ●3 ●3

The Large() function returns a numeric value, which represents the nth largest value in a range of data. It cannot return a text value directly. However, you can use other functions, such as INDEX and MATCH, or IF and TEXT, to return a related text value based on the output of the Large() function.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss