I need a formula that will go through all the cells in a sheet, and search for a particular text value in the cells. The formula should then list down the addresses of the cells that containing this value. Can it be done?
I need a formula that will go through all the cells in a sheet, and search for a particular text value in the cells. The formula should then list down the addresses of the cells that containing this value. Can it be done?
you'll need to use VBA.
attach a sample workbook and desired result format.
Yes, this can probably be done with a formula, but I would need to see what you are working with, what you want, and how you want it, so, as suggested above, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks