How to get only uniq value (without conflict) by using primary key in MS Excel 2007?
Dear Team,
I have a 3 columns data in MS Excel 2007 in which Codes are promary key.
In another sheet, I will select codes where projects to be displayed but projects code should not be repeated (match-Index-array may be used), I tried formulae (=INDEX($I$6:$I$152,MATCH($K$10,$B$6:$B$152,0))) but project names are not resulting as per my requirement.
Please share your idea and hint so that i can implement. (Excel sheet copy is attached)