find |

Find specific values out of duplicates

You I have data in A:A. This data may contain duplicates. In B:B I have a list with data that will definitely be in A:A. What I want my code to do is run …

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 …

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 …