Hi don't worry about it, it's all good.

Basically i have a group of paycodes based on different levels of experience, hence the 0,1,2,& 3. My payroll tool and HR tool however do not talk to eachother so Payroll has them all down as QARXX0 and not any 1,2 or 3. The average rate in my file however is based on the 1,2,3.

So what i was trying to do was based on the 0 code i have in payroll, find the closest rate in the sample rate i gave to the correct code. I have hundreds of paycodes like the sample provided.

Not sure if that makes sense. But like i said, dont worry. Its all good.

Thanks again,
Jon