Hello everyone
I don't know wheter it's me but I am incapable of finding anything on the internet that can do this:
- I have a row that varies in length (between 100 and 200)
- I want to find a text in that row, like "Text"
- If a match occurs, I want to get the column number, like 5 and the column letter, like "E"
So far I tried this:
It does not work, apparently I cannot use .column? Any help would be appreciated.
Please Login or Register to view this content.
Thanky you
You can use Column if Text is found.
Instead of Find why not try using Match?
Please Login or Register to view this content.
If posting code please use code tags, see here.
This UDF might help
If you want the column letter(s) change this linePlease Login or Register to view this content.
toPlease Login or Register to view this content.
Enter the text to find in B1, and the row number in D1Please Login or Register to view this content.
The result is in F1
Formula:
Please Login or Register to view this content.
See the attached.
Last edited by Marcol; 11-18-2012 at 11:27 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
This might be more useful
To Return Letter(s)Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
To return Number
Formula:Please Login or Register to view this content.
Thank you all guys
I ended up using this:
Great forum, really :D :D :DPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks