Functions

Switched up to Excel 2007 lost functionality in my array equations
Okay, I have a dataset that I have a program datamine and produce the required information into an Excel worksheet. Was using the .xls worksheet, but with moving to 2007 and getting an upgraded data mining program I had to move them to the .xlsx or .xlsm. But when I moved it to the .xlsx all of my arrays will... 10 Feb 2010 15:42

Empty Cell-conditional formatting
I have a column where I enter a date when a document arrives. If it is left blank for more than 7 days I need an alert. I also have a start date in A1 to refer to. It would be 7 days from the start date, I would need the cell red or "ALERT". Thanks! SMack ... 10 Feb 2010 22:29

Text to Columns
500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks ... 10 Feb 2010 14:34

Lookup / Index/Match
My spreadsheet is setup as follows: Column A B C D E County Road Starting Mileage Ending Mileage Road Type Alan 52 0 5 Highway Alan 52 ... 11 Feb 2010 08:19

Why wont my right click functions work?
I can not copy, paste, merge cells, or anything else with a right click. How do I change these settings. ... 10 Feb 2010 13:26

Cell Color Recognition and Summing of Data Within a Specified Colo
I've tried SUMIFS to recognize cell colors and add the numbers (which are hours worked in the day) in the corresponding row. The kicker is the yellow cell doesn't necessarily have the same hours and I can't get Excel to recognize colors only for one of my criteria. It could range from 2 to 12 hours for any gi... 10 Feb 2010 13:26

EXCEL
I need to total a column of numbers eg 'R' but only if the column 'I' says 'DES'. -- BobT ... 11 Feb 2010 13:57

Change How Tab Operates
Somehow, I've changed how my Tab Operates in Excel. How can I change back to when I hit Tab, it simply moves over one column? ... 10 Feb 2010 14:34

formula to subtract from inventory total
Hello, I would like to set up a spreadsheet where I have a call with a total number of paqs that I have in inventory. I have a column called Units where I enter the units a customer orders. I would like to have excel subtract the number of units in the Units column from the cell where I have the total number o... 10 Feb 2010 13:26

Turn off speak cells
How do you turn off speak cell (when you enter a number in a cell in speaks it)? ... 11 Feb 2010 18:30