ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   modifing the find function (https://www.excelbanter.com/excel-discussion-misc-queries/180464-modifing-find-function.html)

Chris

modifing the find function
 
I would like to know how to set up a button that will open an input box and
search for a particular value in only one column. This would be similar to
find but with a specific range( one column) and would ask find next at the
end.

Thanks,


Gary''s Student

modifing the find function
 
I have great news for you! FIND can be made to look at only one column.
Just select the column before you pull-down:

Edit Find
--
Gary''s Student - gsnu200774


"Chris" wrote:

I would like to know how to set up a button that will open an input box and
search for a particular value in only one column. This would be similar to
find but with a specific range( one column) and would ask find next at the
end.

Thanks,



All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com