YD Scuba Diving Forums banner

1 - 8 of 8 Posts

·
Sorry for being a dick
Joined
·
1,757 Posts
Discussion Starter #1 (Edited)
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.
 

Attachments

·
Can't resist the shiny things.
Joined
·
297 Posts
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
 

Attachments

·
beyond a mid-life crises into complete insanity!
Joined
·
1,394 Posts
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 :)
 

·
Sorry for being a dick
Joined
·
1,757 Posts
Discussion Starter #4 (Edited)
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
 

·
Sorry for being a dick
Joined
·
1,757 Posts
Discussion Starter #6
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.
 

·
Sorry for being a dick
Joined
·
1,757 Posts
Discussion Starter #7
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
 

Attachments

1 - 8 of 8 Posts
Top