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 to

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

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 A

They share an orange.