Ig nore this. I'm just doing a test. I hope that's okay.

If nobody else wants to/is willing to, I'll completely mail it in and SUPER slank. But it'll go awful.

I'm not Lissa. I just do her job.

Hello friends and mafia friends. INVITATION TO THE MAFIA CHAMPIONSHIP (SEASON 7) Ahoy there! 🙂 I’m very excited to invite your community to participate in Season 7 of the Mafia Championship. The Mafia Championship is an annual forum-based tournament series that pits representatives from various online Mafia (aka Werewolf) communities against one another as they compete to determine the Internet’s greatest forum Mafia player. Each participating community democratically elects one person to represent them and be their “Champion”. The tournament first started back in 2013. Since then, 320+ different communities and 50+ different nationalities have been represented. It’s a super fun event that has created many new friendships and close bonds between communities. I hope that you would be interested in taking part 🙂 1. DO YOU ACCEPT THE INVITATION? If your community wishes to participate, please confirm your participation to Lissa as soon as you can to ensure yourselves a spot. Currently, the plan is to accommodate 150 communities this season. If there is further interest, additional communities may sign up as substitutes; generally there are some replacements needed both before and during games. If your community agrees to participate, the deadline for selecting your representative is April 27, but the sooner the better. The games will take place on Mafia Universe. If it’s okay, I can link directly to the general discussion thread regarding this topic on Mafia Universe. Important notes You may decide yourselves how you want to elect your representative, but we highly recommend some sort of democratic process (public nominations followed by a poll usually works out well). In addition to electing a representative, you should also name an alternate who will be asked to step in if the first choice needs to back out. Your representative should be prepared for having to read upwards of 500-600 posts per 24 hours during the early stages of the game. Additionally, there’s a requirement that each player must make at least 10 posts per Game Day. Only active players should apply/participate. I repeat: Your chosen player needs to be able to promise a good amount of activity on a daily basis. 2. SEASON 7 FORMAT The tournament structure 150 communities will participate, each sending one representative. QUALIFIERS: 10 Qualifier Games will be played, consisting of 15 players each. I.e. every representative plays in one Qualifier Game. The players themselves vote post-game to determine who is deserving of advancement. 1st and 2nd place will advance to the Semifinal Games. SEMIFINALS: A Jury consisting of finalists from Season 6 will select 25 additional players to advance to the three Semifinal Games. From each game, five players will advance to the Finale Game based on a post-game player vote, just like in the qualifying phase. THE FINALE: The Finale Game is played. Once it has completed, the players vote to determine who shall receive the title of Season 7 Champion and a winner’s certificate signed by Dmitry Davidoff, the creator of mafia. This year’s setup: JOAT^2 The setup is called JOAT^2 and features 15 players. The setup consists of the following: 3x Mafia Goon 2x Town Jack Of All Trades (9x Doctor, 9x Motion Detector, 9x Tracker) 10x Vanilla Townie Note that the Jacks Of All Trades must use all three actions before repeating an action, i.e. they are rotating. This does not mean they must use the actions in the same order every time. Relevant mechanics info - Day start. - Majority lynch is enabled Day 2+, but majority is not required at any point in order to lynch. - Tied votes will result in a player being lynched at random from among the tied players. - No outside communication. I.e. you may not contact the other players outside of the thread (unless you are Mafia and wish to speak with your teammates). - Phase Lengths and Deadlines will be up to the players themselves (I’ll organize your representative into a game with deadlines that suit their preferences). - Thread is locked during Night Phases. - Votes are automatically locked in at LYLO. - Mafia factional kills are assigned. They can be tracked, watched, roleblocked, etc. (In this setup, that means they display as an action to the Tracker and the Motion Detector actions.) - Mafia share a factional Night Kill, which is a single standard shot for their faction. The mafia faction kill is mandatory. - Mafia may communicate at any time. - Each individual player may make a maximum of 150 posts per day phase (this restriction is lifted 2 hours before day end). - The game will have a host to oversee everything and make sure everyone’s following the code of conduct, but otherwise the game is completely automated (automatic votecounts, thread locks and reveals roles automatically, the bot receives and processes actions, etc.). 3. SEASON 7 TIMELINE There will be 10 Qualifier Games, and your representative plays in just one of these. They will have start dates ranging from late April to mid-June. So in other words, as long as your representative can play sometime during that period, they should be good and I’ll make sure they get scheduled into a game that suits their schedule well. I.e. if your rep is busy until June, that isn’t a problem. The Semifinal Games will be played in July, and the Finale Game sometime in August/September (whenever we can work out something that suits everyone). If you want to get in contact with me ASAP, you can find me on Discord (Lissa#8083). Kind regards, Lissa

Which makes this the most successful sign-up in years.

I'm pretty sure your wife is looking for a way out.

Back off, I called dibs. And welcome <3

Hey Sirren! Welcome.

Probably should have read your more recent post before responding, but as indicated above, the error is likely caused by blank cells.

No, the formula is only designed to count numbers. So while 4, 78643623214, and 42.4444 would get picked up, 231R will not. If you have alphanumeric characters that you're trying to count, such as the serials 231R and 6160, try this formula instead. =SUM(IF(FREQUENCY(MATCH(A2:A6700,A2:A6700,0),MATCH(A2:A6700,A2:A6700,0))>0,1)) As you can see, it returns 7 unique values - "doesn't" "really2" "matter" "what4" "Iwritehere" "4" and "5". The only issue is there MUST be something in each cell for your data range. In other words, if you put A2:A6700, all 6,699 cells must not be empty. You can put a serial number, a period, a blank space...whatever you'd like...but it cannot be blank or you'll get a #NAME? error.

Just specify the arrays for what you want to count. If you only want to count the first column, for example, it should just be A1:A7000, A1:A7000 (or whatever the last row you want to count is). If everything you want is in Column C, replace A with C.

Try this function: =SUM(IF(FREQUENCY(A1:B10,A1:B10)>0,1)) This is for two columns of data, with numbers in cells A1 - A10 and B1 - B10. Using the example data set you provided, it would be A1:A9,A1:A9, unless you needed a second row. Of course, you can make your dataset as expansive as you want in the formula and affect nothing, if the columns are blank (or strings). For example: As you can see, it returns a total of three for the sample dataset you provided and ignores everything in the B column. Adding a number to the bottom of column B increases the freq. sum in A12. This is with the same formula in A12, of course. I just clicked off the cell before my second screenshot. I hope this helps. If it doesn't work quite right, let me know and I'll see if I can tweak it for you.

They share an orange.