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.