Jun 20, 2012 · I am trying to accomplish something similar but am at a loss. I need to find the row number of a cell with text. Normally a match function would work perfectly but the text is not …

Aug 17, 2009 · Hi guys I have a worksheet full of data where, when the sheet is protected, the 'Find' function (Ctrl F) will not work. When it is unprotected it it fine. Any idea how I can keep …

Dec 2, 2010 · The search function is returning the NUMBER of the character. i.e. =search ("p",supply) will return 3 because the 1st "p" in supply is the 3rd character. So in your formula …

Apr 17, 2019 · How to change Spreadsheet search (find) results cell border colour ? Seems so easy, but just cannot find anywhere that shows you. Excel 365 currently shows dark green, but …

Mar 6, 2008 · The find function returns the character position of the first thing it is trying to find which in this case is the comma. So basically, it is trying to find a "," in New York, New York. …

Nov 13, 2022 · Hello, I have encountered an issue when trying out the Range.Find() function in one of my workbooks: the function returns the very value I gave it instead of the cell where it …

Mar 13, 2014 · The Find function allows me to look in Formulas, Values and Comments, but the Find and Replace function only allows me to look in Formulas. I could have sworn that I …

Jan 27, 2005 · Is there a formula I can use to see if a cell is highlighted? I need to filter for highlighted cells and want to use a formula to produce a binary result (1 for highlighted or 0 for …

Oct 4, 2007 · I have a sheet with a list of names on and I've noticed that when I use ctrl+F to use the find function, even when I know i have entered the correct name it still will not work. I have …

Aug 30, 2005 · Hi all I have some structured data which uses indentations to display a hierarchy (in the "Format Cells" dialog under "Alignment" there is a box "Indent" which shows the …