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: users+unsubscr...@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
