Hi All,
We have framed the email pattern for the first name and last name. We need the formula to identify which of these pattern we had framed. Which is in H Column highlighted in blue color. I have attached the same file.
Thank You
Hi All,
We have framed the email pattern for the first name and last name. We need the formula to identify which of these pattern we had framed. Which is in H Column highlighted in blue color. I have attached the same file.
Thank You
Last edited by sathishkm; 03-02-2022 at 06:02 AM.
Expecting 35 Combinations in formula?
UDF will be the right approach.Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
How can we do UDF ?
=Epattern(A2:G2)Please Login or Register to view this content.
And thanks to Sixthsense: I used his table to help generate the code.
Last edited by JohnTopley; 03-02-2022 at 11:03 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
This excel macro is not able to get the result.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks