J
JBoulton
Hi, All!
My table contains very long text in a NAME field (longest is 7
characters.) Many of the records are only slightly different from eac
other. Data/Filter/Advanced/Unique can differentiate between th
records but dget() and dsum() return values as though the function
only look at some limited number of characters in the text field.
Does anyone know if that's true and what the limit is?
I have completed the analysis by creating a unique key based on th
NAME and then using vlookup() to get the correct NAME back afterwards.
I had to use:
=mid(NAME,len(NAME)/2,6)&mid(NAME,len(NAME)/3,6)
TIA
Ji
My table contains very long text in a NAME field (longest is 7
characters.) Many of the records are only slightly different from eac
other. Data/Filter/Advanced/Unique can differentiate between th
records but dget() and dsum() return values as though the function
only look at some limited number of characters in the text field.
Does anyone know if that's true and what the limit is?
I have completed the analysis by creating a unique key based on th
NAME and then using vlookup() to get the correct NAME back afterwards.
I had to use:
=mid(NAME,len(NAME)/2,6)&mid(NAME,len(NAME)/3,6)
TIA
Ji