Hello
I am writting for the first time and i really need help
I am trying to find a way to search in a specific column, part of a text and give back as a result the sell that include the text.
I have find out how to search for a specific word, the whole word and have back my result but not with part of the text.
Is it possible someone to help me please?
The function i use is: =ADDRESS(MATCH("NATASA";A:A;0);1)
Thank you very much
Try this:
=ADDRESS(MATCH("*NATASA*";A:A;0);1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you very much, that is amazing...can i ask something last?
If more that one cells contains part of the text is it possible to have as a result all the cells?
Not in a single formula, no. A complex array formula would have to be constructed and put in several cells. It's a noticable increase in complexity.
If it's a must, you'll need to post a workbook showing all this... the data, the reference cell that has NATASA in it, and the cells that would show the multiple results. Mock it all up manually so it clear visually. Click GO ADVANCED and use the paperclip icon to post up your workbook.
Re: Find part of a text in a column and give as a result the position of the text
I have discover another function suitable with my problem but i can't find a way instead of true or false to have as a result the value of the cell
The function is:=ISNUMBER(FIND("NAT";A:A))
And i have a mini example:
NATASA TRUE FALSE
DIMITRISFALSE FALSE
MARIA FALSE FALSE
ATHINA FALSE FALSE
AGGELIKIFALSE FALSE
KSANTHI FALSE FALSE
I would like instead of TRUE to have the text NATASA
Thank you again for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks