Does anyone knows the formula to Find the Maximal String, Based on Alphabetic Order
I have a column with data:
AB001
AB002
EF001
EF002
EF003
KE001
KE002
KE003
AB003
I need a formule which gives me the Maximum String in the Strings starting with EF so the result of my formula must be => EF003
Thanks for helping me out. I appreciate
I have a column with data:
AB001
AB002
EF001
EF002
EF003
KE001
KE002
KE003
AB003
I need a formule which gives me the Maximum String in the Strings starting with EF so the result of my formula must be => EF003
Thanks for helping me out. I appreciate