Salary History report...need help

[nitin.asalkar]

Hi all,

I have data in following format (for all employees).
0001 Vasant Rade 08-Oct-03 LYI K4/10 K4/10 7900 9000
0001 Vasant Rade 29-Aug-04 LYI K4/10 K4/10 8600 10000
0003 Ramesh Malusare 29-Aug-04 LYI T4/4 T4/6 9800 11000
0003 Ramesh Malusare 03-Oct-05 GYI T4/6 T4/7 10500 12000
0003 Ramesh Malusare 11-Sep-05 LYI T4/7 T4/7 11300 13000

I would like to have employee-wise report in another worksheet...somting like below:
Employee Salary History Report
Emp No
Name of Employee

Effective Date Type GradeBefore GradeAfter OldBasic NewBasic

Can you please help in creating this report. I have attached the MS Excel file in which I have compiled the data.
Regards
Nitin Asalkar

[Fotis1991]

Hi and welcome to the forum.

One way is this.

In B3, put this.

Please Login or Register  to view this content.

In A6 and copy down and across, use this Array(C+Sh+En) formula.

Please Login or Register  to view this content.

Done.?