2020 Archives by date, by thread · List index

# Re: [libreoffice-users] bug in LARGE function?

```On 25 Nov 2020 at 20:09, stmoose wrote:

Date sent:              Wed, 25 Nov 2020 20:09:39 -0700 (MST)
From:                   stmoose <st.moose@gmail.com>
To:                     users@global.libreoffice.org
Subject:                [libreoffice-users] bug in LARGE function?

```
```if I have done this correctly, this link (
) should give you access to a file that I have trying to get the LARGE
function to work

created in calc 7.0.2.2 since updated to 7.0.3 (but large function not
working, or at least not how I thought it should :(

a summary of what I have in case you cant download the file

in cell b4 to z4 are values 320, 320, 320, 320, 320, 320, 320, 320, 320
,320, 320, 320, 320, 320, 320, 320, 322, 322,323, 323, 323, 323, 323, 323,
323

in cell b8 formula =LARGE(B4:Z4,2)   gives the result 323   (but I would
think that it should return 322? - right?
i am using the LARGE function incorrectly?

thanks
```
```
322

"=LARGE(A1:A25,COUNTIF(A1:A25,MAX(A1:A25))+1)

It the above doesn't paste correctly.
To get the 322 result you expected found this formula on
https://stackoverflow.com/questions/20011864/how-to-find-the-first-and-
second-maximum-number

322
"=LARGE(A2:A26,COUNTIF(A2:A26,MAX(A2:A26))+1)

Data
"=Large(\$A\$2:\$A26,2)
"=RANK(A2,\$A\$2:\$A\$26)
"=LARGE(\$A\$2:\$A\$26,ROW()-1)

320
323
10
323

320
323
10
323

320
323
10
323

320
323
10
323

320
323
10
323

320
323
10
323

320
323
10
323

320
323
10
322

320
323
10
322

320
323
10
320

320
323
10
320

320
323
10
320

320
323
10
320

320
323
10
320

320
323
10
320

320
323
10
320

322
323
8
320

322
323
8
320

323
323
1
320

323
323
1
320

323
323
1
320

323
323
1
320

323
323
1
320

323
323
1
320

323
323
1
320

Again if the above paste doesn't work correctly.
Data    "=Large(\$A\$2:\$A26,2)    "=RANK(A2,\$A\$2:\$A\$26)
"=LARGE(\$A\$2:\$A\$26,ROW()-1)
320     323     10      323
320     323     10      323
320     323     10      323
320     323     10      323
320     323     10      323
320     323     10      323
320     323     10      323
320     323     10      322
320     323     10      322
320     323     10      320
320     323     10      320
320     323     10      320
320     323     10      320
320     323     10      320
320     323     10      320
320     323     10      320
322     323     8       320
322     323     8       320
323     323     1       320
323     323     1       320
323     323     1       320
323     323     1       320
323     323     1       320
323     323     1       320
323     323     1       320

Interesting that Rank returns only 1, 8, and 10 for values.
Largest seems to sort values, and for rank returns that on of the set of
values..
"=LARGE(A2:A26,COUNTIF(A2:A26,MAX(A2:A26))+1)
CountIF process calculates you need to get the 8th largest value to get
the 2nd largest range of values..

Assuming that is what you want it to do??
Hope that helps.

```
```

--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/

```
```

+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/