RaviWildcat
Board Regular
- Joined
- Jun 18, 2010
- Messages
- 119
- Office Version
- 365
- Platform
- Windows
- MacOS
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?
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?