How to distinguish between case and ignore #N/A values and empty values, and extract unique items
Ranges A1:E20
The difference between uppercase and lowercase letters, and the order of the characters with the difference between uppercase and lowercase is not fixed, there are #N/A values and empty values in the search range
Column H is the result. The order may not follow mine, as long as the result can be obtained.
Can someone please help me ? It would be much appreciated. Thanks in advance
Bookmarks