I want to make a excel file where i'll search with partial text & output result will show multiple result which is match with this text
here i attach a sample file
Thanks
Shaif
I want to make a excel file where i'll search with partial text & output result will show multiple result which is match with this text
here i attach a sample file
Thanks
Shaif
Misread the Search term !!!!!
Last edited by JohnTopley; 04-14-2016 at 07:46 AM.
Hi
Try with a helper column
In D2 use this formula and copy down
Formula:Please Login or Register to view this content.
In A21 use this formula and copy right and down
Formula:Please Login or Register to view this content.
Regards
Hi
Cell A21This is array formula? Press same time (Ctrl+Shift+Enter)till you see both end {} DO NOT PRESS ENTER ON IT OWN otherwise it won't workFormula:Please Login or Register to view this content.
Last edited by micope21; 04-14-2016 at 07:36 AM.
To help you by my post? it would be nice to click on to say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Enter as regular formula in cell A21 and copy across and down
Formula:Please Login or Register to view this content.
Last edited by AlKey; 04-14-2016 at 12:19 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks