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 <macroche...@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+h...@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:mi...@kuentos.guam.net mailto:msetze...@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+h...@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
