Jump to content

DRAGONMOUNT

A WHEEL OF TIME COMMUNITY

Clovdyx

Member
  • Content Count

    8577
  • Joined

  • Last visited

About Clovdyx

  • Rank
    Fading fast
  • Birthday 06/25/1988

Recent Profile Visitors

3710 profile views
  1. Which makes this the most successful sign-up in years.
  2. Back off, I called dibs. And welcome <3
  3. Probably should have read your more recent post before responding, but as indicated above, the error is likely caused by blank cells.
  4. 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.
  5. 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.
  6. 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.
  7. This thread makes me wish I never got the Internet.
  8. 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 work better, it might not. Sorry I can't give you a more helpful answer. tabletest.html tabletest2.html
  9. how the hell you change avatars

×
×
  • Create New...