Convert text strings to a code or number
On Wed, 22 Mar 2006 07:47:28 -0800, MaxNY23
wrote:
In column A and B I have text representing an Entity and its Intercompany,
respectively. In column C I have concatenated the two. So now in Column C,
for example, I have "BillTom" in row 1 and "TomBill" in row 900.
I need Excel to convert the text into some sort of code, ASCII or number
that shows they are EQUAL. I need something that shows "TomBill" and
"BillTom" are the same thing, just in a different order.
I cannot build an IF formula or use Find/Replace, as I will have thousands
of these types of combinations.
Thanks!
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
|