Ask Your Question
4

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

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

plato gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

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

lakamha gravatar image

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

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

Add Answer


Question Tools

Stats

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

Seen: 3 times

Last updated: Mar 31