Excel DGET double match #num error. Windows 7 - XL-07

football

New Member
Joined
Jan 11, 2014
Messages
2
Name
Class
Last
New Average
ImproveHigh SlowHigh TimedX's
Ed
Master
276274-3 84964
Mark
Master276
2782 9095
5
Steve
Master2802800 86
97
5
Nathan
Master275271-4 82974

<colgroup><col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> <col style="mso-width-source:userset;mso-width-alt:4644;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:804;width:17pt" width="22"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:1097;width:23pt" width="30"> </colgroup><tbody>
</tbody>

High TimedX's
975
#NUM!


<colgroup><col><col></colgroup><tbody>
</tbody>

Formula is returning #NUM =DGET(A7:L11,"NAME",H38:H39)


I am not having any success trying to complete this scoring program.
I am trying to get the "name" of the person with the highest score. The above formula returns the correct name as long as there are no two scores the same.
In the database above, in column High Timed, there are two scores of 97, but the deciding criteria should be the number of X's

Is there a way to write a formula that would return the name of the person with the highest score, taking into account the number of X's.

The correct return in the above case should be "Steve" not "Nathan"

Than you in advance.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
NameClassLastNew AverageImprove High SlowHigh TimedX's High TimedX's
EdMaster276274-3 84964 975
MarkMaster2762782 90955
SteveMaster2802800 86975 Steve
NathanMaster275271-4 82974

<COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2673" width=75><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2816" width=79><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4636" width=130><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3242" width=91><COL style="WIDTH: 13pt; mso-width-source: userset; mso-width-alt: 597" width=17><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3527" width=99><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4010" width=113><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5319" width=150><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3328" width=94><TBODY>
</TBODY>

A:I houses the data; L1:M2 is the area with the criteria.

L4:

=DGET($A$1:$I$5,"NAME",$L$1:$M$2)
 
Upvote 0
NameClassLastNew AverageImproveHigh SlowHigh TimedX'sHigh TimedX's
EdMaster276274-384964975
MarkMaster276278290955
SteveMaster280280086975Steve
NathanMaster275271-482974

<tbody>
</tbody>

A:I houses the data; L1:M2 is the area with the criteria.

L4:

=DGET($A$1:$I$5,"NAME",$L$1:$M$2)


That works!:)
Thank you for your help
 
Upvote 0

Forum statistics

Threads
1,215,032
Messages
6,122,772
Members
449,095
Latest member
m_smith_solihull

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top