G
Guest
I have a column of data that is in text format:
ex:
'0215
'6251
'5489
'2351
'6350
'5126
How can I reference this data in another cell while keeping the same format.
For example:
I am trying to extract all of the unique values in my column of data by
using the formula I found on cpearson (=IF(COUNTIF($A$1:A1,A1)=1,A1,"")) This
formula works great but the data that it returns does not contain the
apostrophy in front of the number which is needed. I have tried having the
cell be equal to "'"&A1 if the formula is true but the the apostrophy is
visible and still doesn't wok with the sume product. Any help on this would
be greatly appreciated.
Chad
ex:
'0215
'6251
'5489
'2351
'6350
'5126
How can I reference this data in another cell while keeping the same format.
For example:
I am trying to extract all of the unique values in my column of data by
using the formula I found on cpearson (=IF(COUNTIF($A$1:A1,A1)=1,A1,"")) This
formula works great but the data that it returns does not contain the
apostrophy in front of the number which is needed. I have tried having the
cell be equal to "'"&A1 if the formula is true but the the apostrophy is
visible and still doesn't wok with the sume product. Any help on this would
be greatly appreciated.
Chad