Military Rate/Rank Formula

T

TechD87

Greetings Excel Gurus,

I would first like to thank everyone who will attempt to assit me i
this matter as it has been a complete pain in my ass since I firs
checked into my command over a month ago.

So heres what I have...

I have a Master Excel sheet that lists everyone in the command (Name
Rank, DOB, ect). However I also work with a completely seperate lis
that needs to be provided to another command with similary but ye
different variables. As some of you may or may not know, the Navy ha
"Rates" that designate a persons specific type of Job. For example, I'
an IT2 (E-5) that works alongside a YN2 (also an E-5).

Heres what I want to do...

I would like to take the Master List with the "Rate" column, and creat
a formula to automatically convert it to the basic (E-1, E-2, E-3, ect)
But since there are 64 types of rates, only the last 2 (or in E-4 to E-
rates, 1) characters are similar. By spending alot of time doin
research, I'm coming to the conclusion that I need to somehow create a
"IF, RIGHT, and VLOOKUP" formula to make this work.

Anyone possibly know how to do this? I'm currently working with Exce
2007
 
M

Mazzaropi

TechD87;1611637 said:
Greetings Excel Gurus,
I would first like to thank everyone who will attempt to assit me i
this matter as it has been a complete pain in my ass since I firs
checked into my command over a month ago.
So heres what I have...
I have a Master Excel sheet that lists everyone in the command (Name
Rank, DOB, ect). However I also work with a completely seperate lis
that needs to be provided to another command with similary but ye
different variables. As some of you may or may not know, the Navy ha
"Rates" that designate a persons specific type of Job. For example, I'
an IT2 (E-5) that works alongside a YN2 (also an E-5).
Heres what I want to do...
I would like to take the Master List with the "Rate" column, and creat
a formula to automatically convert it to the basic (E-1, E-2, E-3, ect)
But since there are 64 types of rates, only the last 2 (or in E-4 to E-
rates, 1) characters are similar. By spending alot of time doin
research, I'm coming to the conclusion that I need to somehow create a
"IF, RIGHT, and VLOOKUP" formula to make this work.
Anyone possibly know how to do this? I'm currently working with Exce
2007.

*TechD87*, Good Afternoon.

Attach a small spreadsheet with a clear example about what you desire.
Fill some data.

I believe that will be easier and quicker to give you an answer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top