Re: [libreoffice-users] Calc Formula Help

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: users+help@global.libreoffice.org
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