Without the help of Pivot.

[Santhoshhrishi]

Hi,

I am with one other query here. Pl help.

If i select the ID from column K, in cloumn L the name should get displayed.

Column M, should populate during which all years particular employee had went through increment/ appraisal cycle.(Should display all the years an employee had went through appraisal)

Column N, should populate the CTC details w.r.t the appraisal year.

As on date i was using Pivot table for this, but i believe there must be certain functions to crack this. Pl help.

Note: In the sheet i have the pivot output as well fyr., So without pivot pls help me in arriving at similar output.

[Glenn Kennedy]

Try this out...