I changed the formatting on spreadsheet including color filling, add border, bolding fonts, wrap text and merge cells, then I saved the file. Nearly all...

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells: a1 - contents= 1/1/2010 b1 - contents= null c1 - contents "CLOSED" All...

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells: a1 - contents= 1/1/2010 b1 - contents= null c1 - contents "CLOSED" All...

I have data in the following form and I need a formula to produce the contents of the Formula result column. Invoice Product Value Formula result 1 car 10 No...

Is it possible to change all of the tabs names in my workbook (using something similar to "find & replace"?? ex: workbook tabs names: Q107, Q207, Q307,...

I use a sheet to track when I receive items, once per day, and I log the time in 24 HR format using numbers, no formatting. I want to be able to count how...

Hi, I have a question about a slightly complicated Rank function I want to write, and I’m having a problem with it. Say you have the following...

Hi, I'm trying to build a formula which looks at a set of data and compares them against 3 variables: product (text) currency (text) number (number) to get...

HI does anyone know of a workaround as a formula for this VBA code. Range("A1:U200").Select test = Selection.Find(What:="40237", After:=ActiveCell,...

I am trying to get a formula to return a number if two other cells have values. Column X might have a number or a letter; Column Y will have a number. For a...

Hi, I have a question about a slightly complicated Rank function I want to write, and I’m having a problem with it. Say you have the following...

I have 4 employees inspecting properties based on zip codes. Each employee has multiple zipcode assigned to them (as few as 4 and as many as 12). How do I...

I am looking to create a formula that will see if a value from column 1 sheet 1 is present in column 1 sheet 2, and if it is, return the value from column 2...

Hi, I have a question about a slightly complicated Rank function I want to write, and I’m having a problem with it. Say you have the following...

Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as...

Hi, Thanks in advance for any input you can give on this. I'm trying to organize a messy schedule, so I'm using the sumproduct function. The data available...

is there anyway to stop the auto format I need to enter 1-4-1 1-4-2 1-4-3 etc... and the data showes up as dates in the cells I hate this auto function and I...

am making a form for signing up items. Need to number column cells (1, 2, 3...) without having to do it manually. Is there a function that will do it for...

I'm using the following formula but am getting #N/A values on some of the cells: =VLOOKUP(VALUE(LEFT(B88,5)),List!A:C,3,0) I would like it to return "empty"...

a b c d 1 .2 yes yes .3 2 .5 no no .5 3 .1 yes maybe 0 So, as in the above example, I need to put a...