If cell contains part of a differnt cell range then enter the number
Hi, Could anyone figure out a formula for this? If A2 contains all the text (not an exact match) from any cell from range B2 …
VBA Find Sub
I need a VBA sub that will use the title of a sheet to find the matching text on another sheet and use that text as reference to retrieve other data in the …
VBA FIND/REPLACE
Hello, I need to replace certain words (which are written in ” “) from SPanish to English As I have over 500 words, I want to automize the …
how do i search jpgs from an excel sheet?
I have a file of 1000+ jpgs and a list in excel of 300 file names – how do i search and find the 300 images in the bigger file? do i do this via dir …
Find cell value in matrix and return the value below
Jag letar efter ett sätt att hitta ett unikt värde i en matris och sedan returnera värdet i raden under det. Column 1 Clumn 2 Column 3 Bird …
Get a cell reference of a value, in a worksheet (multi column/row, no “sorting” of values).
Looking for the function to state the cell reference of a given value in a worksheet (array). Value “2” ,located in A1, and located in …
Find text separated by line breaks in same cell
Is it possible in Excel to find text within a cell separated by line breaks? Suppose the text consists of the following in the same cell: “aaa” on …
How can Find possibly work
Hi, I am a contract developer working for a company going back in time to the desire for a VBA application so I am brand new at this. I am looking at a …
Country Manager
Hello all, can someone help with the following issue. From one worksheet to another in excell, i need the formula to sellect a column and …
Excel searching and formulas
Ok, so I’ve got a spreadsheet with a list of pipe sections with the following properties:column A: diametercolumn B: thicknesscolumn C: section …