correction level 5 with 19 now.
correction level 5 with 19 now.
I've found an easy way of checking the values in a column for duplicates, figure this might be useful when the list gets bigger. I can't add it in myself at the moment due to high traffic, so thought I'd explain it here so someone else can add it when things slow down a little.
Copy the following formula into a cell next to the first value:
= IF(ISBLANK(B2) ; IFERROR (1/0) ; IF( COUNTIF (B:B,B:B)>1 ; 1 ; IFERROR(1/0)))
Where 'B' should be the appropriate column (I used column B, figuring the formula would go in column A), and 'B2' should be the cell containing the first code. After that you can just drag the formula down by clicking on the little square at the bottom right of the cell - this will increment the cell identifier automatically (i.e. B2 changes to B3, B4, B5, etc), so you don't have to put this in manually 120 times.
What this will do is place a '1' in the cell corresponding to any duplicates values. This can then be colour coded by selecting all the cells with the formula in, and then going to format > conditional formatting and setting that up with whatever colour you deem appropriate.
Sorry if that's a bit basic, but I figured too much info's better than not enough. Also, I didn't come up with the formula, just modified it a bit.
So are these forum names our character names? Thanks for the codes.
Doubtful. Usually you can name your toon whatever.Originally Posted by KILLER
No new code but I did dig through some source code and css to get a sneak peak at all of the icons once unlocked...
http://cdn.defiance.com/defiance/images/icons.png
Some interesting hints as to what some of them are... firestorm looks like it might be a flamethrower.
I want the scavenger perk... sounds like a loot booster.
PC - UberNinJa
"level":"Level","arkhunter_level_0":"Ark Hunter","arkhunter_level_1":"Beginning Bionetics","arkhunter_level_2":"VBI Basic Training","arkhunter_level_3":"Post-Arkfall-Geology","arkhunter_level_4":"Intermediate Bionetics","arkhunter_level_5":"Frontier Survival School","arkhunter_level_6":"Urban Warfare","arkhunter_level_7":"Marksmanship Course","arkhunter_level_8":"Military Tactics","arkhunter_level_9":"Advanced Bionetics","arkhunter_level_10":"Munitions Training","arkhunter_level_11":"Weapon Modification","arkhunter_level_12":"Off-Road Course","arkhunter_level_13":"Indoor Firing Range","arkhunter_level_14":"Endurance Course","arkhunter_level_15":"Final Exam and Field Test","arkhunter_level_15_congratulations":"Congra tulations Ark Hunter, you have attained the highest honor and reached level 15. You're now ready to lead the charge on the new frontier!","points_until_singular":"Submit %c more code to progress and unlock your next reward.","points_until_plural":"Submit %c more codes to progress and unlock your next reward.",
Yes that it does. Could also be something simple, like increasing the amount of ammo that drops from a kill
I used to be an eager Ark Hunter like you, then i took a "soon" to the ear.
i have been putting in the codes but nothing is happening do i need 2 b on the beta for it 2 work i have put in more than 1 code but nothing is being unlocked
Posting Permissions
Reply With Quote
