Countif for values where len >=259

[RaviWildcat]

Hi Everyone -

Maybe it's just me!

I've got a table with issue IDs and Descriptions. I was looking for issue IDs with duplicate descriptions so naturally I added an extra column with a countif - count how many times the description appears in the description column.

(I'm on my work computer so I'm apprehensive about installing the macro showing the functions but you get the gist If the descriptions are in column G, then H1 looks like (countif(g1:g10,g1)

I'm noticing that count if will work perfectly on strings that are less than 259 characters. If the string is longer than 259 characters then I receive a #value error!

I created a separate table containing descriptions 259 characters or larger and receive the same #value error

Of course I can get around this by creating a cheat column that captures the first 259 characters of the fields I'm trying to count but that seems like cheating

Is this happening for anyone else?

 

[Fluff]

The limit is actually 255 characters, anything more will return an error.

 

[RaviWildcat]

I figured as much! Thanks for confirming!

 

[Fluff]

You're welcome.