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
Last edited by rayhen; 08-02-2021 at 01:54 AM.
First of all, I have to explain. At the time, I was successful when I POST. Later, how did I search for the post again and disappeared. I have tried 5 to 6 times, and I uploaded it after confirming that there was none.
You could have found it via the My Posts link above. And you have just posted to it, so it clearly did not disappear.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks ALIGW
H2=INDIRECT(TEXT(MIN(IF((ISERROR(FIND($A$1:$E$20,CONCAT(H$1:H1))))*(NOT(ISERROR($A$1:$E$20))),ROW($A$1:$E$20)*10+COLUMN($A$1:$E$20),11111)),"R00C0"),)&""
control+shift+enter
@CAABYYC It's amazing, you're so amazing, thank you
@rahen Your EXCEL version is so old that you can run CONCAT FUNCTION, this function is only available in at least 2019 or 365
provide you EXCEL 2019/365 solution if you want
Cell H2 formula , drag down
HTML Code:
I happened to use his computer at my brother's house, because he has installed MS365 so he can run it
WOW is so wonderful, you can still use it like this, @wk9128 you are too good, I will receive your help again
You're Welcome. @Rayhen Thank You for the feedback . Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks