Different words Same letters

[panyagak]

Hi all MrExcelians!

I have 2 columns with different words. I would like to identify those different words with same letters.

Any non-Array formula would do to use on my smartphone.

thanks n regards
Patrick

 

[Legacy 143009]

It is quite impossible to achieve without an array on mobile. Even it is challenging to do on a non-365 platform.

If I were you I would go with a setup similar below.

The formula is:

=MID(OFFSET($A$2,COLUMN(A$1)-1,0),ROW($A1,1)

Then I would copy and paste the letters as Values.
Then I would apply filter and sort columns A to Z. This will make the eyeballing much more easier.

 

[panyagak]

Flashbond.

suppose you assign values 1-26 to A-Z, I think would be easier then I can filter then I can do comparisons

thank you

 

[Legacy 143009]

suppose you assign values 1-26 to A-Z, I think would be easier then I can filter then I can do comparisons

Very clever indeed

 

[Peter_SSs]

@panyagak
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

For example, if you have the relevant functions available, you might be able to use something like this, where the number in column B indicates how many words in the list contain the same letters as the adjacent word in column A.

23 10 09.xlsm
	A	B	C
1	angel	3	aegln
2	angle	3	aegln
3	Heart	2	aeHrt
4	there	1	eehrt
5	Earth	2	aEhrt
6	dangle	1	adegln
7	glean	3	aegln
Check letters

Cell Formulas
Range	Formula
B1:B7	B1	=COUNTIF(C$1:C$7,C1)
C1:C7	C1	=CONCAT(SORT(MID(A1,SEQUENCE(LEN(A1)),1)))