Functions

Removing Special Characters
Hello, I exported to Excel 2003 my Outlook Calendar and now I have a lot of odd little square characters that I cannot remove. Any suggestions please? Thank you! Cathy ... 23 Mar 2010 16:00

find all instances of a search item and put result in a single cel
Is it possible to search a column in one sheet for all occurrences of a search item and then put the result of that search in a single cell on a second sheet? For example, Sheet 1 may have something like this: A :: B John yellow Mary yellow Sue red Richard green ... 23 Mar 2010 21:46

How to know if a worksheet was unlocked
Hi! I have a worksheet containing many formulas. This worksheet is locked without any password. Is there a way to see if somebody unlocked the worksheet to change formulas? I want the user can unlock and lock back the worksheet, but I need a way to know it. Thanks! ... 23 Mar 2010 18:22

Way do do search/replace on beginning/end of cell w/o functions?
Hi, I've been writing various functions to search/replace beginning/ends of cells, however wondering if there is a way to do the simpler ones with just Search/Replace function. In word I'd just do ^pString orString^p but not sure if there is a symbol I can use to mean beginning/end of cell. For insta... 23 Mar 2010 03:27

annualize sales for remainder of year
I have a figure for YTD Sales and am trying to calculate estimated annualized sales off of this. And, this will change monthly as sales managers update their YTD sales to actual for the prior month end. Mathematically, the formula would be: YTD Sales + ((YTD Sales/# whole months passed) (# whole months remain... 23 Mar 2010 13:40

Question about syntax for conditional formatting (RESOLVED)
Thank You for all your comments, Very useful. "Cbeckwith" wrote: See below: Can someone explain the following in simple language; =AND($B$12<>"",$B$12<TODAY()+120) What does the <> after the cell location mean? and why the double quotes ""? I thought the double quotes meant whatever is... 22 Mar 2010 13:06

Is this an Index/Match formula?
Hello - I have 2 tabs of data. The first tab has info by product and its qualifying vendors and non-qualifying vendors (the vendors are in seperate columns) ColumnA ColumnB ColumnsC ColumnD ColumnE Product X Vendor1 Vendor2 Vendor3 Vendor4 Column A will always be unique Columns B and C are ... 22 Mar 2010 20:41

HLOOKUP into another xls file
=HLOOKUP(Summary!F7,'[CPW(IBM) SD Weekly Report Week 43.xls]Wk43'!$N$3:$S$3,1) The above works, however sheet which is WK43 in this example and the workbook changes everyweek hence I need to change these values. The workbook name will be in C2 and the worksheet will be in D2, however when I try to build the f... 23 Mar 2010 10:09

multiple correlations with one click?
I have a numerical data set with 11 columns and 1809 rows. I would like to simply obtain a table of correlations involving Col 1 with each remaining Col (Col 2 thru Col 11), then Col 2 with each remaining Col (3 thru 11), then Col 4 with each remaining Col (5 thru 11), and so on until the last correlation, i.e., Co... 22 Mar 2010 19:15

EOMonth function
Is there an equivalent function to EOMonth in xl2003 or a formula that will get me the same result? ... 22 Mar 2010 13:06