Excel2007Filter: I want to be able to search information between two things in a single cell in Excel. So a cell may have 4-9 typed in it, but I want that cell to be highlighted if a user searches for 7. Or 4. Or anything between 4 and 9 inclusively. (More details and a screenshot of the spreadsheet inside.) [more inside]
posted by sperose on Sep 2, 2009 - 3 answers

How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]
posted by SansPoint on Sep 2, 2009 - 5 answers

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

ExcelFilter: Help me count rows where one string appears in one column and a second string appears in a second! [more inside]
posted by Alterscape on Aug 14, 2007 - 5 answers

Help me get a professional massage! What is a "named range" in Excel and how do I create one? I cannot import an .xls file into her outlook contact folder until I address this issue. [more inside]
posted by sourwookie on Jul 5, 2005 - 6 answers