software

I'm trying to identify the person with the lowest score in the column.
I'm using the formula

=IF(J16=quot;1quot;,LOOKUP((MIN(J4:J15)),J4:J15,$D$4:$D$15 ),quot;quot;)

Column D represents the names
Column J represents their score
cell J16 indicates there was 1 low score

Sometimes I get the right name and sometimes I get #N/A.--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: www.excelforum.com/member.php...oamp;userid=30600
View this thread: www.excelforum.com/showthread...hreadid=505478Why the quotes around the digit 1? Surely the 1 in J16 is numeric not text
I tried =IF(J16=1,LOOKUP((MIN(J4:J15)),J4:J15,$D$4:$D$15), quot;quot;)
with some dummy data and it worked.

Also try
=INDEX($D$4:$D$15,MATCH(MIN(J4:J15),J4:J15,0))
OR
=IF(J16=1, ($D$4:$D$15,MATCH(MIN(J4:J15),J4:J15,0)) ,quot;quot;)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;pdgaustintexasquot;
lt;pdgaustintexas.229d2t_1138306253.4849@excelforu m-nospam.comgt; wrote in
message newsdgaustintexas.229d2t_1138306253.4849@excelfo rum-nospam.com...
gt;
gt; I'm trying to identify the person with the lowest score in the column.
gt; I'm using the formula
gt;
gt; =IF(J16=quot;1quot;,LOOKUP((MIN(J4:J15)),J4:J15,$D$4:$D$15 ),quot;quot;)
gt;
gt; Column D represents the names
gt; Column J represents their score
gt; cell J16 indicates there was 1 low score
gt;
gt; Sometimes I get the right name and sometimes I get #N/A.
gt;
gt;
gt; --
gt; pdgaustintexas
gt; ------------------------------------------------------------------------
gt; pdgaustintexas's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30600
gt; View this thread: www.excelforum.com/showthread...hreadid=505478
gt;

Sorry, none of those formulas worked just right.

The reason for the quot;1quot; is that cell J16 has a formula to find the
_only_ lowest number =IF(FREQUENCY(J4:J15,(MIN(J4:J15)))=1, quot;1quot;,quot;quot;)

Basically what this is is a golf tournament scorecard. I have a list
of names per flight. I want to find the lowest score per hole and the
player who shot it. 2 or more low scores, the cell is left blank. The
formula I'm using only works on a few names, otherwise I get #N/A.--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: www.excelforum.com/member.php...oamp;userid=30600
View this thread: www.excelforum.com/showthread...hreadid=505478That really is not the way FREQUENCY is used. Try
=IF(COUNTIF(J4:J15,MIN(J4:J15))=1,1,quot;quot;)
I do not understand why you have put the 1 in quotes when it is numeric.
In my answer I mistyped the second formula; it should be
=IF(J16=1,INDEX($D$4:$D$15,MATCH(MIN(J4:J15),J4:J1 5,0)),quot;quot;)If you really want text in J16 use
=IF(COUNTIF(J4:J15,MIN(J4:J15))=1,quot;1quot;,quot;quot;)
and
=IF(J16=quot;1quot;,INDEX($D$4:$D$15,MATCH(MIN(J4:J15),J4: J15,0)),quot;quot;)

Both version work for me.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;pdgaustintexasquot;
gt; wrote in
message newsdgaustintexas.229fe2_1138309207.653@excelfor um-nospam.com...
gt;
gt; Sorry, none of those formulas worked just right.
gt;
gt; The reason for the quot;1quot; is that cell J16 has a formula to find the
gt; _only_ lowest number =IF(FREQUENCY(J4:J15,(MIN(J4:J15)))=1, quot;1quot;,quot;quot;)
gt;
gt; Basically what this is is a golf tournament scorecard. I have a list
gt; of names per flight. I want to find the lowest score per hole and the
gt; player who shot it. 2 or more low scores, the cell is left blank. The
gt; formula I'm using only works on a few names, otherwise I get #N/A.
gt;
gt;
gt; --
gt; pdgaustintexas
gt; ------------------------------------------------------------------------
gt; pdgaustintexas's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30600
gt; View this thread: www.excelforum.com/showthread...hreadid=505478
gt;

IT WORKS!! Thanks alot! --
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: www.excelforum.com/member.php...oamp;userid=30600
View this thread: www.excelforum.com/showthread...hreadid=505478
IT WORKS!! Thanks alot! --
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: www.excelforum.com/member.php...oamp;userid=30600
View this thread: www.excelforum.com/showthread...hreadid=505478