Jump to content

DRAGONMOUNT

A WHEEL OF TIME COMMUNITY

Clovdyx

Member
  • Content Count

    8581
  • Joined

  • Last visited

About Clovdyx

  • Rank
    Fading fast
  • Birthday 06/25/1988

Recent Profile Visitors

4142 profile views
  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. Probably should have read your more recent post before responding, but as indicated above, the error is likely caused by blank cells.
  6. 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
  7. 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.
  8. 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
×
×
  • Create New...