By Debra Dalgleish, on July 12th, 2012
can return a value from a range of cells, and the
can calculate a value's position in a range of cells.
For example, in the screen shot below, cell A7 contains the item name, Sweater:
the MATCH function can find "Sweater" in the range B2:B4. The result is 1, because "Sweater" is in the first row of that range.
the INDEX function can tell you that in the range C2:C4, the first row contains the value 10.
So, by combining INDEX and MATCH, you can find the row with "Sweater" and return the price from that row.
=INDEX($C$2:$C$4,MATCH(A7,$B$2:$B$4,0))
Find a Match for Multiple Criteria
In the previous example, the match was based solely on the Item name – Sweater. Sometimes life, and Excel workbooks, are more complicated.
In the screen shot below, each item is listed 3 times in the pricing lookup table. To get the right price, you'll need to specify both the item name and the size. We want to find the price for a large jacket.
Does it MATCH? True or False
Instead of a simple MATCH formula, we'll use one that checks both the Item and Size columns. To do something similar on a worksheet, we could add columns to check the item and size columns.
If the Item in column B is a Jacket, the result in column E is TRUE. If not, the result is FALSE
If the Size in column C is Large, the result in column F is TRUE. If not, the result is FALSE
In column G, when you multiply the TRUE/FALSE values, the result is 1, only if both are TRUE.
We could use a MATCH formula to find the position of a 1 in column G, in the screen shot above. The 8th row of data (worksheet row 9), has the 1, and that row will give us the correct price for a large jacket.
Use MATCH With Multiple Criteria
Instead of adding extra columns to the worksheet, we can use an array-entered formula to do all the work. Here is the formula that we'll use to get the correct price, and below is the explanation:
=INDEX($D$2:$D$10,
MATCH(1,(A13=$B$2:$B$10)*(B13=$C$2:$C$10),0))
NOTE: This is an array-entered formula, so press Ctrl + Shift + Enter, instead of just pressing the Enter key.
In this example,
prices are in cells D2:D10, so that is the range that the INDEX function will use.
item name is in cell A13
size is in cell B13.
The formula checks for the selected items in $B$2:$B$10, and sizes in $C$2:$C$10. The results are multiplied.
(A13=$B$2:$B$10)*(B13=$C$2:$C$10)
The MATCH function looks for the 1 in the array of results.
MATCH(1,(A13=$B$2:$B$10)*(B13=$C$2:$C$10),0)
If you select that part of the formula and press the F9 key, you can see the calculated results. In the screen shot below there are 9 results, and all are zero, except the 8th result, which is 1.
So, the INDEX function returns the price – 40 – from the 8th data row in column D (cell D9).
To find the product code for the selected item and size, you would change the formula to look in cells A2:A10, instead of the price column.
=INDEX($A$2:$A$10,
MATCH(1,(A13=$B$2:$B$10)*(B13=$C$2:$C$10),0))
In this example, the product code would be JK003, from cell A9.
More INDEX and MATCH Examples
For more tips and examples, and to download the sample file, please visit the
on the Contextures website. This is Example 4 in the sample file.
_____________
&&Name (required)
&&Email (will not be published) (required)
Name (optional):
Recent Posts
Contextures
1516182021
2223252728
CategoriesCategories
Select Category
30XL30D&&(32)
Communication&&(14)
Excel Books&&(10)
Excel charts&&(35)
excel dashboards&&(4)
Excel Data Validation&&(92)
Excel Filter&&(43)
Excel Formatting&&(64)
Excel Formulas&&(194)
excel printing&&(1)
Excel Shortcuts&&(28)
Excel tables&&(4)
Excel Templates&&(34)
Excel tips&&(406)
excel training&&(7)
Excel Utilities&&(12)
Excel VBA&&(152)
Hardware&&(4)
Internet&&(23)
Microsoft Excel Versions&&(2)
Microsoft Office&&(24)
Pivot Table&&(85)
PowerPivot&&(4)
Productivity&&(29)
small business&&(9)
Software&&(13)
Select Month
January 2016 &(5)
December 2015 &(5)
November 2015 &(8)
October 2015 &(9)
September 2015 &(8)
August 2015 &(5)
July 2015 &(5)
June 2015 &(7)
May 2015 &(8)
April 2015 &(9)
March 2015 &(9)
February 2015 &(7)
January 2015 &(8)
December 2014 &(8)
November 2014 &(9)
October 2014 &(9)
September 2014 &(8)
August 2014 &(4)
July 2014 &(4)
June 2014 &(12)
May 2014 &(13)
April 2014 &(13)
March 2014 &(13)
February 2014 &(12)
January 2014 &(12)
December 2013 &(11)
November 2013 &(12)
October 2013 &(10)
September 2013 &(8)
August 2013 &(9)
July 2013 &(9)
June 2013 &(8)
May 2013 &(9)
April 2013 &(9)
March 2013 &(8)
February 2013 &(8)
January 2013 &(8)
December 2012 &(6)
November 2012 &(9)
October 2012 &(9)
September 2012 &(9)
August 2012 &(9)
July 2012 &(9)
June 2012 &(8)
May 2012 &(10)
April 2012 &(8)
March 2012 &(9)
February 2012 &(8)
January 2012 &(7)
December 2011 &(7)
November 2011 &(5)
October 2011 &(13)
September 2011 &(13)
August 2011 &(14)
July 2011 &(13)
June 2011 &(13)
May 2011 &(13)
April 2011 &(12)
March 2011 &(12)
February 2011 &(14)
January 2011 &(30)
December 2010 &(14)
November 2010 &(13)
October 2010 &(13)
September 2010 &(13)
August 2010 &(13)
July 2010 &(13)
June 2010 &(13)
May 2010 &(13)
April 2010 &(13)
March 2010 &(14)
February 2010 &(12)
January 2010 &(13)
December 2009 &(13)
November 2009 &(13)
October 2009 &(13)
September 2009 &(12)
August 2009 &(9)
July 2009 &(10)
June 2009 &(9)
May 2009 &(13)
April 2009 &(17)
March 2009 &(17)
February 2009 &(20)
January 2009 &(20)
December 2008 &(19)
November 2008 &(20)
October 2008 &(23)
September 2008 &(22)
August 2008 &(22)
July 2008 &(25)
June 2008 &(22)
May 2008 &(13)
April 2008 &(1)
March 2008 &(1)to add this item to your wishlist, follow it, or mark it as not interested
Languages:
Full Audio
Portuguese-Brazil
Includes 29 Steam Achievements
Title: Hotline Miami 2: Wrong Number
Developer:
Publisher:
Release Date: 10 Mar, 2015
Buy Hotline Miami 2
Buy Hotline Miami 2: Wrong Number - Digital Special Edition
Packages that include this game
Buy Hotline Miami 1 + 2 Combo Pack
Includes 2 items:
Hotline Miami, Hotline Miami 2: Wrong Number
Buy Hotline Miami 2: Wrong Number - Digital Special Edition Upgrade
Downloadable Content For This Game
“In almost every way, Hotline Miami 2 is a marked improvement on an already tremendous formula.”
9/10 –
“Hotline Miami 2: Wrong Number is a great game and a worthy sequel. It’s more confident in its style, storytelling ability, and level design than the first game.”
8.8/10 –
“Hotline Miami 2: Wrong Number is unapologetic and unforgettable.”
8.5/10 –
Hotline Miami 2: Wrong Number | Digital Comics
Download the Hotline Miami 2: Wrong Number digital comic series by Dayjob Studio and dive into the backstory of several factions on a path to confrontation. The entire five-part series is free to download and comes in a single app that launches from your Steam library.
About This Game
Hotline Miami 2: Wrong Number is the brutal conclusion to the Hotline Miami saga, set against a backdrop of escalating violence and retribution over spilled blood in the original game. Follow the paths of several distinct factions – each with their own questionable methods and uncertain motivations – as unforeseen consequences intersect and reality once again slips back into a brilliant haze of neon and bloodshed.
Blistering combat against punishing opposition will require intense focus as new variables, weapons, and methods of execution are introduced throughout the struggle. Let the striking colors of an unmistakable visual style wash over as you meticulously cut down those that would stand between you and the ultimate meaning behind the massacre. This is the finale, this is the unquestionable end.
Relentless Hostilities: Adjust combat techniques as the narrative shifts between factions and brings unique variations to a familiar approach along with new weapons, movements, and melee attacks.
Enthralling Soundtrack: Over forty pounding tracks from dozens of artists punctuate the savage conflict and bring the larger scale of your actions into focus. New artists join returning favorites like M|O|O|N, Perturbator, Jasper Byrne, Scattle, and El Huervo for an incredible audio massacre.
Custom Level Editor: Design custom levels using characters, enemies, weapons and music tracks from the game and share your creations with others online via Steam Workshop. [COMING SOON]
The Hotline Miami 2: Wrong Number Digital Special Edition includes the Hotline Miami 2 Wrong Number Remix EP featuring six remixed tracks from M|O|O|N, Scattle, and Carpenter Brut.
***Please note that the Hotline Miami 2: Wrong Number Digital Special Edition does not include the full soundtrack. The full soundtrack is a separate purchase and includes all 49 tracks with the proceeds going to the artists themselves.***
The Hotline Miami 2: Wrong Number Digital Special Edition also includes free access to the Payday 2 &Jacket Character Pack& that includes the character items and weapons below.
All owners of Hotline Miami 2: Wrong Number on Steam - standard or Special Edition - will receive an exclusive mask pack in Payday 2.
System Requirements
SteamOS + Linux
Minimum:
OS: Microsoft(R) Windows(R) Vista / 7 / 8
Processor: 2.4 GHz Intel Core 2 Duo or better
Memory: 1 GB RAM
Graphics: OpenGL 3.2 compatible GPU with at least 256MB of VRAM
DirectX: Version 9.0c
Storage: 600 MB available space
Additional Notes: PS4 or Xbox 360 Controller or Direct Input compatible controller
Recommended:
OS: Microsoft(R) Windows(R) Vista / 7 / 8
Processor: 2.8 GHz Intel Core 2 Duo or better
Memory: 2 GB RAM
Graphics: OpenGL 3.2 compatible GPU with at least 512MB of VRAM
DirectX: Version 9.0c
Storage: 600 MB available space
Additional Notes: PS4 or Xbox 360 Controller or Direct Input compatible controller
Minimum:
OS: Mac OS 10.7+
Processor: 2.4 GHz Intel Core 2 Duo or better
Memory: 1 GB RAM
Graphics: OpenGL 3.2 compatible GPU with at least 256MB of VRAM
Storage: 600 MB available space
Recommended:
OS: Mac OS 10.7+
Processor: 2.8 GHz Intel Core 2 Duo or better
Memory: 2 GB RAM
Graphics: OpenGL 3.2 compatible GPU with at least 512MB of VRAM
Storage: 600 MB available space
Minimum:
OS: Ubuntu 12.04 or later
Processor: 2.4 GHz Intel Core 2 Duo or better
Memory: 1 GB RAM
Storage: 600 MB available space
Recommended:
OS: Ubuntu 12.04 or later
Processor: 2.8 GHz Intel Core 2 Duo or better
Memory: 2 GB RAM
Storage: 600 MB available space
Copyright 2015 Dennaton Games. All Rights Reserved.
More like this
Loading reviews...
Loading reviews...
Loading reviews...
Loading reviews...
15 people found this review funny
29.3 hrs on record
Having played 28 hours of this game, I've decided to tell you why I think that this game is worth every cent.Obviously, It is absolutely imperative that you play the original game BEFORE playing this one.Hotline Miami 2: Wrong Number is a game developed by Dennaton Games and published by Devolver Digital and serves as the sequel for Hotline Miami, a &A hyper-violent top-down shooter/brawler& and one of the most critically aclaimed indie games of all time.The game takes place after, during, and before the events of its predecessor and manages to maintain some of the frantic action that popularized the first game, HOWEVER, Wrong Number is much more story focused than the the original and serves as the developers way to tie up loose ends.The gameplay retains certain aspects of from Hotline Miami but the levels are designed in such a way that you have to cower in fear behind each door and wait for the perfect moment so as to not get either snipped by a shotgun from across the map or spotted through a window.I, like most people, didnt enjoy this kind of level design, because there are enemies outside your camera's range who can react faster than you and end what seemed like a perfect run.One of the aspects the latter didnt retain from the former was the melee combat. In this game, melee combat was somewhat nerfed, making the melee swing slower and the and the range smaller.One of the most controversial characteristics of Hotline Miami 2 is its relatively large cast of playble characters. But Haplop, how could more characters equal less fun.Well for starters you have more characters but less unique playstyles. There are 27 masks each with their unique gimmicks and playstyles opposed to the 14 characters of Hotline Miami 2. Whats more is that there most characters dont add anything new, here's whats new.Fists of Fury,(used by 2 different characters), lethal punches, cant pick up any weapons, wich renders it sorta useless since the levels are so big.Dodge Roll,(used by 2 different characters) you press space to dodge in the direction you are pointing and become invincible in the mean time, can sometime cause you to miss floor executions.Chainsaw and Guns,(unique) you control one of 2 sibllings wich (the one rocking the chainsaw), with your right mouse button you force the second sibling to shoot. The AI on the second sibling can be kinda buggy, and will sometimes become stuck behind walls while you charge inside a room full of mobsters armed to the teeth with nothing but a chainsaw.Two machine guns, (used by 2 different characters) you start with 2 smgs, you can have 64 bullets and can only reload once, after that, there is nothing special to it.Start with a nailgun,(unique)- 24 nails, silent killer, nothing out of the ordinary.Inner warrior,(unique) Fists of Fury with nunchucks.Remember the Richter and Aubrey mask from the previous game? They now grant no special abilities.There is also a character wich instead of killing can incapacitate and disarm foes for bonus points.You also get to play as a soldier wich can switch between a knife and one of for weapons ( a rifle, a shotgun, a sniper rifle and a flamethrower) but cant pickup any other weapons.The soundtrack is just downright beautiful featuring the works of El Huervo, M|O|O|N, Perturbator and many other independent artists, it can go from slow and melancholic to full on assault in seconds and it really does not only live up to the standards set by the previous game but somehow also manages to surpass them by a pretty big stretch.Not only that but the audio in general is really descriptive and the mushy sound of grey matter splattering all over the room does add to the gory factor of the game, wich by the way, makes great use of the Hitchcock effect (google it)The sprites may seem a bit, how should I put it, wonky (?) at first but after playing through it you realize that it is one of the best way to convey to the player the setting of Miami's 1980's. Overall the game in itself is great, the gameplay isnt as satisfying as that of the 1st game but the story is beautifully written. Its a much more down-to-earth game and the story always has you feeling sorrowful and melancholic while still keeping you interested and engaged as you watch this immensely dense plot unravel before your eyes while you cant really do anything about it.I guess that that is what really gives you a sense of accomplishment, once you manage to get the bigger picture that is.So...Do you still like hurting other people?Let me know if you agree with this review or not.
Was this review helpful?
121 people found this review funny
26.8 hrs on record
The only sexual content in this game is
the huge throbbing erection you get from the soundtrack
Was this review helpful?
20 people found this review funny
36.3 hrs on record
After praising this game for ages, I think its time to review it.Pros: -Fun gameplay-Awesome Story-Best soundtrack ever.-Interesting Characters-Thick skinCons:-VERY Hard (You'll break your R key before beating the game) (This can be a pro depending on your opinion)-Large Levels (This wouldn't be an issue if you wouldn't died almost instantaneously)-WINDOWS-Too many long distances between enemies with guns... and they can see you when you can't see them-Not the soundtrack------------------------If you love a challenge, hard games, or not getting lunch, I recommend it. If you don't like hard gameplay, I still suggest the soundtrack, as its only 15$ for 42 songs
Was this review helpful?
204 people found this review funny
7.2 hrs on record
If sex on drugs was a video game.10/10
Was this review helpful?
427 people found this review funny
47.0 hrs on record
I rate 0/10, oops thats the wrong number..
Was this review helpful?
Loading reviews...
You can use this widget-maker to generate a bit of HTML that can be embedded in your website to easily allow customers to purchase this game on Steam.
There is more than one way to buy this game. Please select a specific package to create a widget for:
Hotline Miami 2
Hotline Miami 2: Wrong Number - Digital Special Edition
Hotline Miami 1 + 2 Combo Pack
Hotline Miami 2: Wrong Number - Digital Special Edition Upgrade
Enter up to 375 characters to add a description to your widget:
Copy and paste the HTML below into your website to make the above widget appear
Share:& & &
VAT included in all prices where applicable.&&
View mobile website01-1301-0112-0311-2411-2210-2710-27
04-1308-2708-2708-2208-1908-1908-19
07-1505-1306-0403-2703-1203-0503-05
12-2410-1909-1708-0807-2307-2304-08
01-1601-1501-1312-2312-1912-1512-05
·04-22·10-19·04-21·07-25·06-19·09-18·06-30·09-09·11-20·07-16
视频攻略推荐
人气攻略排行榜
《龙之信条：黑暗觉者》将包含原始游戏的所有内容，此外开拓了一片广阔的新天地。这里有25种新怪物，更高等级的技能，优化过的体验及菜单，此外还有100件新装备。如果玩家们保
《Gigantic》（暂译《巨兽》）是一款由美国游戏工作室Motiga开发的网络射击游戏。游戏由5名玩家组成一个团队，他们与有5层楼高的巨型兽一起守卫各自的阵营，与对方展开激烈战斗。玩
《天使帝国4》是《天使帝国》系列的正统续作，距上一部作品《天使帝国3》已有十多年之久。本作拥有全新的故事，虽然同样在爱斯嘉大陆这块土地上，但时空背景已经经历了数千年
······
游戏下载排行榜
终极剪辑版包括以下内容：-整合了之前发售的三部作品的战役，修查看: 7677|回复: 5
【速攻组审核】《收获日2》《PAYDAY 2》游戏点评、评测
帖子主题积分
游民步兵, 积分 168, 距离下一级还需 332 积分
金钱240 ￥
魅力208 点
在线时间19 小时
本帖最后由 筱航 于
11:15 AM 编辑
013221brfaffzzbbbzp90z.jpg (102.45 KB, 下载次数: 12)
12:31 AM 上传
评测员：筱航、
《收获日2》是本人一直期待的一款游戏，
虽然算不上什么大手笔、大制作，但它就是这样激起了无数个男孩儿的激情和战斗欲。
没有更多的渲染，没有更多的优化，更没有很多很多的高科技。4个人4把枪4个特性职业。为了生存赚着用生命换来的每一分钱！
我还记得《收获日1》还没上市的时候，很多玩家都把它说成是一款把僵尸换成警察的《求生之路》。
玩家亲自上手以后发现，PAYDAY给大家带来的真的不仅仅是打僵尸那么一点点的乐趣。
现如今我们玩过的FPS游戏，千款百态，数不胜数，但是让我们能够流连忘返，偶尔还想小刺激一下的真不多了。
但《Payday 2》是我本人最爱的FPS之一！
暴力、刺激、个性化、独一无二
游戏画面&&
payday2_win32_release
00-02-19-39.jpg (178.26 KB, 下载次数: 13)
12:56 AM 上传
角色待机画面
payday2_win32_release
00-05-38-82.jpg (170.66 KB, 下载次数: 18)
01:01 AM 上传
游戏、Steam、组队画面
《收获日2》自定义面具，改装武器。这些算是游戏给玩家的另一个小惊喜吧，武器改装现在已经不是什么新鲜事了。
但是偏偏在这个游戏最主角的地方它增加了一项可以改装属于的面具，这个就有意思多了。很渺小的一个细节，赢得了很多玩家的喜爱
这也算是成功了。
payday2_win32_release
01-08-35-45.jpg (110.18 KB, 下载次数: 12)
01:10 AM 上传
自定义面具界面，可以根据在任务中得到的资源材料，
改装属于你自己的面具！COOL！！
payday2_win32_release
01-09-04-68.jpg (131.96 KB, 下载次数: 17)
01:11 AM 上传
武器改装界面，过任务得材料，改武器。用过的改装件，当你不需要这个武器的时候
还可以卸下来按到其他武器上。
payday2_win32_release
01-06-38-46.jpg (346.66 KB, 下载次数: 12)
01:13 AM 上传
payday2_win32_release
01-06-43-57.jpg (195.72 KB, 下载次数: 17)
01:13 AM 上传
如果你的电脑可以达到最高画面的话，其实这个款游戏还是不错的。
payday2_win32_release
00-03-53-24.jpg (300.77 KB, 下载次数: 12)
01:21 AM 上传
任务选择界面，每个任务出现都有时限，难度越高给的报酬越高，
想拿到更多的钱，那你就一定要有一帮够狠的兄弟
如果你是一个人带着AI过完了这个游戏，那么我想你可能只玩到了这个游戏3分之一的乐趣。
payday2_win32_release
00-09-08-53.jpg (210.58 KB, 下载次数: 18)
01:21 AM 上传
任务载入界面
在这里可以看到任务提示，自身出行装备，任务要点和消费式任务有利条件。
还可以查看队友的随身装备。非常清晰的一张战斗准备图。
PATDAY能凭着一身平凡打入游戏者内心，它不是靠宣传，靠炒作。
3个月红遍全球Steam，它不是刷出来的，也不是吹捧吹来的
精细的画面，不过分的渲染，简单的操作，不完美的优化
就这样，让每一个平凡的人都能快速上手
游戏通过完成任务，获得金钱、武器改装材料、面具改装材料。
游戏每升一级会获得一个技能点和一个解锁武器。
职业天赋共分4个种类，分为黑手、暴徒、技师、幽灵。
每个天赋都有各自的特长技能，通过组队可以各自展现自己的特长
payday2_win32_release
00-02-57-05.jpg (165.11 KB, 下载次数: 18)
12:59 AM 上传
4个特性职业的天赋技能升级画面
很多人对游戏音乐都很有研究和挑剔，
像我们玩极品飞车的时候喜欢听节奏快一些动感的音乐，
我们玩使命召唤的时候喜欢听里面的机械声音、爆炸等一些大动态的音效。
不管是背景音乐还是动态音效，PAYDAY2做的都很到位，
如果你是一个音乐爱好者，你会感受到音效师对这款的用心。
狂野紧张的音乐，紧张夸张的音效都会使你每时每刻都激情百倍
QQ截图18_副本.jpg (501.43 KB, 下载次数: 16)
01:58 AM 上传
本人给大家提供的PAYDAY2的全部歌曲清单
如果有喜欢的朋友可以联系我，也可以自己去网上查。
游戏目录里也有。
总结：《PAYDAY 2》 收获日2
这是一款非常讲究团队合作的一款游戏，每一个队友的行为都形象着整个团队最后的报酬金额
分工明确，团队合作才是这个游戏最大的乐趣。
在很多FPS游戏中团队合作，举目可见，但是像PAYDAY2这样让你真真切切，
感受到是抢劫一家银行的FPS游戏，我相信这是你见过的第一款。
刺激程度和难度都是可以完全满足玩家的，任务难度越高完成的报酬会越丰富
每次游戏结束会出现3张卡牌供你选择，系统会随机给出相应的奖励。
武器改装件、面具改装件、金钱。最后预祝大家抢劫愉快，
本人Steam账号：Joker-H
欢迎各大玩家随时邀请我与你们共同战斗！！
帖子主题积分
金钱83152 ￥
魅力68285 点
威望3532 点
居住地湖北省 武汉市
星座处女座
在线时间9178 小时
排版需要注意下···
JUST DO IT！
帖子主题积分
金钱240 ￥
魅力208 点
在线时间19 小时
飘无絮语 发表于
排版需要注意下···
排版我使用不了&&HTML代码和纯文本模式
帖子主题积分
金钱11015 ￥
魅力8735 点
威望300 点
在线时间422 小时
楼主辛苦了,谢谢分享
帖子主题积分
金钱240 ￥
魅力208 点
在线时间19 小时
liping2008 发表于
楼主辛苦了,谢谢分享
不辛苦的，应该的吗 ·
~！哇哈哈。。。
帖子主题积分
金钱2202 ￥
魅力1910 点
威望101 点
星座天秤座
在线时间145 小时
不得不说这游戏打击感挺强的
财富勋章勋章
申请条件：注册6个月以上。售价5000金，从个人金钱中扣除。
灌水之星勋章
颁发条件：上个月发贴量排行前5者获得。
颁发条件：连续佩戴“灌水之星勋章”达3个月者，将会获得此勋章一枚，且可与灌水之星勋章同时佩戴。
论坛元老勋章
颁发条件：注册达2年，且获得过“杰出贡献勋章”，对论坛有巨大贡献，经管理员审核后获得。
杰出贡献勋章
颁发条件：连续3期拥有积极贡献勋章者可奖励此勋章。
游戏达人勋章
颁发条件：对游戏有很深了解，曾多次发表过有技术性的原创文章。前提条件：注册6个月以上，发贴量500以上。
2000威望值兑换。。。
游民骑士勋章
颁发条件：持续三年活跃在游民，并且做出积极贡献的成员
颁发条件：5000魅力值兑换
颁发条件：精华文章超过10可申请
在线达人勋章
颁发条件：当月在线时间前5名
Powered by