Jump to content

DRAGONMOUNT

A WHEEL OF TIME COMMUNITY

Clovdyx

Member
  • Content Count

    8581
  • Joined

  • Last visited

Everything posted by Clovdyx

  1. If nobody else wants to/is willing to, I'll completely mail it in and SUPER slank. But it'll go awful.
  2. 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
  3. Which makes this the most successful sign-up in years.
  4. Back off, I called dibs. And welcome <3
  5. I really don't even know how it's a debate at this point.
  6. Well, deadpool looks like a cross of Ryan Reynolds and a chihuahua
  7. Probably should have read your more recent post before responding, but as indicated above, the error is likely caused by blank cells.
  8. 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
  9. 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.
  10. 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
  11. I'm not sure what's causing the extra spacing (I believe it's declaring a new paragraph for each line...can't figure out for the life of me why it renders properly in my browser), so I went ahead and tried a different approach for it. One has an extra line break ( < b r > ) in between your email and the first line of text. I'm not sure how much blank space you wanted there, so I included both. I'm also not sure how specific you are on the amount of blank space between the "select"/"staffing" and the blue line, but I think I got it pretty close. Anyways, give this a try - it might
  12. how the hell you change avatars

×
×
  • Create New...