Convert text strings to a code or number
Please reread my original request. I don't think you guys get what I'm
trying to do.
Record a macro while doing WHAT? I'm looking for a function or formula
that converts text to a number. Sort of like the CODE function but for more
that just the first letter of a cell.
I cannot manually mark each row to distinguish it. Again there will be
thousands of rows and hundreds of text combinations.
"Peo Sjoblom" wrote:
Record a macro while doing it
Regards,
Peo Sjoblom
"MaxNY23" wrote in message
...
I can't mark thousands of rows every month, I want Excel do do the
marking/matching via a formula or macro.
Anything else?
"Ron Rosenfeld" wrote:
On Wed, 22 Mar 2006 07:47:28 -0800, MaxNY23
You could mark entries which are duplicates by your rules. Would that be
OK.
For example, in a helper column or as a conditional formatting formula:
=COUNTIF($C$1:$C$10,B1&A1)
would be 1 or more if the reverse concatenation existed in column C
--ron
|