Another problem.
Some of the numbers display as 0 but are calculated so have fractions like
0.0000000812344372353
I want to find the last row that displays as non-zero.
On 2021-01-29 6:30 a.m., Rob Jasper wrote
James,
Since a MINIF function does not exist you can use MINIFS.
Change MIN(B:B) to MINIFS(B:B;B:B;">0”)
Success,
Rob
Op 29 jan. 2021, om 03:59 heeft James <[email protected]> het volgende
geschreven:
I want to find the row in column A that corresponds to the row of a
value in column B.
eg.
row A B
1 10 220000
2 20 150000
3 30 3000
4 40 10
=some_function('A',minimum_function(B));
where minimum_function(B) returns 4 and some_function('A',4) returns the
value in column A at row 4.
I asked the previous and someone gave me the formula:
=INDIRECT("$A"&MATCH(MIN(B:B);B:B;0))
It worked fine but now I have some rows with zeros (more than one row):
row A B
1 10 220000
2 20 150000
3 30 3000
4 40 10
5 50 0
6 60 0
Is there a MINBUTGREATERTHANZERO function?
--
To unsubscribe e-mail to: [email protected]
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
