Hi SunnyKow, As always you bring very clever solution. Thank you very much Dritan
Hi Catalin Bombea Oh that's great solution :), But Aggregate function is for the Excel 2010 and above, what about the Excel 2007, or can i repla...
Great solution, Thank you Anders Sehlstedt for your help. Once again I want to thank you SunnyKow for your suggestion:) Best Regards, ...
Thank you so much SunnyKow for the answer. You are right about the extracted when the character is still "a". But is there any way to do with ar...
Hi SunnyKnow, Yes you are right, I selected the Value in Look in, and I find it. Thank you for your support 🙂
Hi SunnyKow, You have provide a very smart way. But please read my attached file, because still i cannot find a solution. Best Regards, ...
Thank you for your help, You have use a very smart way to solve 🙂
Thank you Mynda, I tried to download your file but the file it doesn't found :(. Can you send me again? thx, Dritan
Thank you for great solution Sunny. In Excel I'm much more familiar with formula, and I face some difficulty using macro.
Thank you Frans.