Thanks for the help - Mod. see: http://www.excelforum.com/excel-prog...-learning.html
I have a real example now. Which I am struggling with.
In the attached file, I want to capture changes in grades, and positions. I can do this with the distinct employee numbers. So if their is a change of Grade, or Position for the same emlployee number, then capture it and place it in a cell.
There is a small example attached. Which shows what the result would look like...
Thanks
Ronan
Bookmarks