Hi,
Michael D. Setzer II schrieb:
If I understand what you are trying to do.
I put this data in Column A and Column B.
COLA COLB
A 7
G 87
T 1
A 1
G 6
T 7
A 43
G 3
T 2
I put the criteria in G1 and G2
COLA
A
Then used the formula to get the value.
=DMIN(A1:B10,"COLB",G1:G2)
That just does it for A, but you could easily setup other criteria to
get the values for the tother letters.
If there might be the need to change the criteria, the above is a
possible way. If you now, that you only need a fix criteria, then you
can include it in the formula using an inline matrix.
=DMIN(A1:B10,"COLB",{"COLA";"A"}). The delimiter between matrix columns
and matrix rows is set in Tools > Options > Calc > Formula. I have
assumed a semicolon as row delimiter here.
Kind regards
Regina
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
