<div>
can you give me output example i mean what you expect as a out put
</div>


can you give me output example i mean what you expect as a out put

<div>
Thank You All. I got the answer.<br />
<br />
=SUMPRODUCT((($D$10:$D$12=<wbr />D10)*($E$1<wbr />0:$E$12=E1<wbr />0)*($F$10:<wbr />$F$12=F10)<wbr />*($G$10:$G<wbr />$12=LARGE(<wbr />$G$10:$G$1<wbr />2,2)))*$G$<wbr />10:$G$12)<br />
<br />
Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     DOB &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Clas &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EmpID<br />
MAX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     20-12-1969 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
MAX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     20-12-1969 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6<br />
MAX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     20-12-1969 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
<br />
<br />
The Data is placed in range(d9:g12)
</div>


Thank You All. I got the answer.

=SUMPRODUCT((($D$10:$D$12=D10)*($E$10:$E$12=E10)*($F$10:$F$12=F10)*($G$10:$G$12=LARGE($G$10:$G$12,2)))*$G$10:$G$12)

Name           DOB                           Clas          EmpID
MAX           20-12-1969           3      2
MAX           20-12-1969           3      6
MAX           20-12-1969           3      4


The Data is placed in range(d9:g12)

<div>
<div class="content wysiwyg-content">
I Have 4 columns viz. Name, DOB, Class &amp;&nbsp;EmpID.<br />
<br />
the first 3 columns have same entry and the last column has different entry.<br />
<br />
Is there any formula in excel to get the answer of the 1st or second entry as for last entry lookup will work.<br />
<br />
Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DOB &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Class &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EmpID<br />
MAX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20-12-1969 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
MAX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20-12-1969 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6<br />
MAX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20-12-1969 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
<br />
<br />
so that if want to get entry for 2nd set, it should come as 6.
</div>
</div>


I Have 4 columns viz. Name, DOB, Class & EmpID.

the first 3 columns have same entry and the last column has different entry.

Is there any formula in excel to get the answer of the 1st or second entry as for last entry lookup will work.

Name	DOB	Class	EmpID
MAX	20-12-1969	3	2
MAX	20-12-1969	3	6
MAX	20-12-1969	3	4


so that if want to get entry for 2nd set, it should come as 6.

MS Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.