Re: [libreoffice-users] Calc Formula Help

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.


On 2 Sep 2011 at 4:05, macroC wrote:

Date sent:              Fri, 2 Sep 2011 04:05:54 -0700 (PDT)
From:                   macroC <macrochelys@gmail.com>
To:                     users@global.libreoffice.org
Subject:                [libreoffice-users] Calc Formula Help
Send reply to:          users@global.libreoffice.org

> So I have two columns of data, column A which has a single character (A, G,
> or T) and column B which has a number. I am trying to determine the minimum
> value in B that corresponds to an "A" in column A.
>
> This is the forumla I came up with after looking at tutorials and reading
> the documentation:
>
> =MIN(IF(A1:A7="A",B1:B7))
>
> But this simple gives a #VALUE error. Can anyone help me figure out what is
> wrong with the formula?
>
> Thanks.
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calc-Formula-Help-tp3303917p3303917.html
> Sent from the Users mailing list archive at Nabble.com.
>
> -- 
> 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


+----------------------------------------------------------+
  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                  
  mailto:mikes@kuentos.guam.net                            
  mailto:msetzerii@gmail.com
  http://www.guam.net/home/mikes
  Guam - Where America's Day Begins                        
  G4L Disk Imaging Project maintainer 
  http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS
SETI        11189934.576302   |   EINSTEIN     6468781.769851
ROSETTA      3563786.501816   |   ABC          7836158.160609


-- 
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