[jb2cool]

I'm currently playing 'Battlefield: Bad Company 2' and i've made a spreadsheet to track my progress towards some acheivements. I know how many kills each weapon needs to reach the next acheivement but is there any way i can get Excel to put this into a list?

What i'd like is for Excel to look at the list of weapons and kills needed and then spit me out a list telling me which gun i should ideally concentrate on (The one with fewest kills needed for an acheivement).

Something like;

AEK-971 Vintovka..........3
WWII M1911 .45..........3
M93R Burst..........3
Stg.77 AUG..........5
MG36..........5
and so on.

I've attached my current workings.

I just can't fathom what i need to ask Excel to do.

 

[Olle]

Erm, something like this? It's pretty dirty but does the trick.
It's just a Vertical Lookup of each weapon and how many kills required to get to the next level and then sorted ascending.

Olle

 

[MJH]

I'm currently playing 'Battlefield: Bad Company 2' and i've made a spreadsheet to track my progress towards some acheivements. I know how many kills each weapon needs to reach the next acheivement but is there any way i can get Excel to put this into a list?

What i'd like is for Excel to look at the list of weapons and kills needed and then spit me out a list telling me which gun i should ideally concentrate on (The one with fewest kills needed for an acheivement).

Something like;

AEK-971 Vintovka..........3
WWII M1911 .45..........3
M93R Burst..........3
Stg.77 AUG..........5
MG36..........5
and so on.

I've attached my current workings.

I just can't fathom what i need to ask Excel to do.

You really have got too much time on your hands

 

[jb2cool]

Erm, something like this? It's pretty dirty but does the trick.
It's just a Vertical Lookup of each weapon and how many kills required to get to the next level and then sorted ascending.

Olle

Olle,
That seems to do the job fine. Thanks!

I don't really 'get' what the the last bit of the formula is saying but i'll use what you have.

EDIT
After playing around with it, i finally see what it's doing and how it works.
Thanks

 

[Repta]

Quite a good way to level up faster, pity i'm **** with half the weapons ive unlocked

 

[jb2cool]

Quite a good way to level up faster, pity i'm **** with half the weapons ive unlocked

I'm pretty poor at killing people to ber honest. I'm much better as cannon fodder and being medic/engineer/ammo boy as well as capturing flags.

I'm good for the team but pretty poor for my own stats.

 

[jb2cool]

Many thanks for the help. I now have a version that does exactly what i want.

If you want to add me to your friends in-game then my BFBC2 username = jb2cool

 

[Olle]

Glad I could help!

Olle