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 ( https://drive.google.com/file/d/1iJ3x4tKNv3Hr9ucYnJqRGWE7Ky8ivfmL/view?usp=sharing ) 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)
I put your numbers in cells A2:A26 instead of B4:Z4.
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/ Privacy Policy: https://www.documentfoundation.org/privacy
+------------------------------------------------------------+ 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/ Privacy Policy: https://www.documentfoundation.org/privacy