-
Content Count
8581 -
Joined
-
Last visited
About Clovdyx
-
Rank
Fading fast
- Birthday 06/25/1988
Recent Profile Visitors
4142 profile views
-
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 to
-
Which makes this the most successful sign-up in years.
-
1-Shot Summer Vacation Mafia Sign-ups [Standard-ish]
Clovdyx replied to keyholder21's topic in Mafia Games's Mafia Board
I'm pretty sure your wife is looking for a way out. -
Back off, I called dibs. And welcome <3
-
Hey Sirren! Welcome.
-
Microsoft Excel Help?
Clovdyx replied to Daruya's topic in The White Tower & Warders's White Tower Public Forum
Probably should have read your more recent post before responding, but as indicated above, the error is likely caused by blank cells. -
Microsoft Excel Help?
Clovdyx replied to Daruya's topic in The White Tower & Warders's White Tower Public Forum
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 -
Microsoft Excel Help?
Clovdyx replied to Daruya's topic in The White Tower & Warders's White Tower Public Forum
-
Microsoft Excel Help?
Clovdyx replied to Daruya's topic in The White Tower & Warders's White Tower Public Forum
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. -
Microsoft Excel Help?
Clovdyx replied to Daruya's topic in The White Tower & Warders's White Tower Public Forum
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 A -
Finish the Joke
Clovdyx replied to Elgee's topic in The White Tower & Warders's White Tower Public Forum
They share an orange.