Very long title, sorry, but I didn't find any other way to say that.
I have cells formatted like text with a code of length, say, five that may contain "0", "1", "2", "3".
Something like that:
01100
10200
30210
00200
10200
00003
01000
I want to find (to sort and eliminate them) all those cells with just one value different from zero. In the example would be the 4th, 6th, and 7th.
Any hint?
Bookmarks