Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 01 Sep 2012 22:02:30 +0200Find minimum value in a columnhttps://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/Need help writing a formula to find the minimum value in a column when the number of rows in the column varies. The cell below the last one in the column is blank, and there are no other blank cells above it. The starting row would be row 2 as row 1 contains headers.
Thanks
MalcolmSat, 01 Sep 2012 11:35:36 +0200https://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/Comment by itsonlyme for <p>Need help writing a formula to find the minimum value in a column when the number of rows in the column varies. The cell below the last one in the column is blank, and there are no other blank cells above it. The starting row would be row 2 as row 1 contains headers.</p>
<p>Thanks</p>
<p>Malcolm</p>
https://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/?comment=5496#post-id-5496Your answer and the superuser question enabled me to solve my problem. ThanksSat, 01 Sep 2012 22:02:30 +0200https://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/?comment=5496#post-id-5496Answer by tohuwawohu for <p>Need help writing a formula to find the minimum value in a column when the number of rows in the column varies. The cell below the last one in the column is blank, and there are no other blank cells above it. The starting row would be row 2 as row 1 contains headers.</p>
<p>Thanks</p>
<p>Malcolm</p>
https://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/?answer=5492#post-id-5492The solution depends if there are other, irrelevant values below (after) the empty cell that should mark the end of the range.
- If there are other cells. you should define a range holding the data cells.
- If there aren't other cells in the row, so the task is simply getting the minimal value from all column values: there's a nice overview in [this superuser question how to reference a complete calc row](http://superuser.com/questions/160435/can-you-reference-an-entire-column-in-openoffice-calc-like-aa-in-excel). So, for example, just use
> MIN(A1:A65536)
or one of the other two variants.Sat, 01 Sep 2012 21:28:23 +0200https://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/?answer=5492#post-id-5492