DUTY LOCATION STATE POSITION TITLE PAY PLAN GRADE SERIES FTE


Washington DC Administrative Specialist GS 12 301 1
Portland OR Administrative Specialist GS 11 301 1
Seattle WA Administrative Specialist GS 12 301 1
Vancouver WA Administrative Specialist GS 13 301 1
Vancouver WA Administrative Specialist GS 13 301 1

See the 2 positions in Vancouver WA in the same Grade? Ultimately I want to
end up with a worksheet that consolidates those two rows and totals the FTE
count thereby eliminating duplicate titles in the same grade, series, and
location.

I.e.:
Vancouver WA Account Specialist GS 13 1101 2

Thanks for your patience and help, Tom, it is really appreciated.


"Jim Thomlinson" wrote:

Can you post a small snippet of data that I can play with. How did you want
to handle Accountants in both MI and WA. My experience with this is that
there is a lot of mix and match of data.
--
HTH...

Jim Thomlinson