I have the following "IF" statement: =IF('officer data'!$AV$4="y",'officer data'!$AR$4,"", IF('officer data'!$BC$4="y",'officer data'!$AY$4,"",...

Suddenly- when I save changes to my workbook sheets it saves a new file -TMP file- to my desktop. How do I stop that? With Appreciation, V

I'm comparing prices at Baker's, Walmart, and Costco. I've got the item, unit cost, size, and cost per ounce. I know how to make comparisons between two...

I have Vista and Outlook 2007 with 2 mail accounts running. On only 1 account, messages get stuck in outbox. Webmail works fine and I can send using Safe...

I am developing a scheduling spreadsheet that will exclude Sundays and Holidays. I have used 'Workday' in the past, but that also excludes Saturdays (which I...

This one is a little weird but this is what I'm trying to accomplish: 1) Find " CE" in both cells A1 & B1 (note there will only be one instance of " CE" in...

What is the best way to set up a mass mailing list of both physical addresses and e-mail addresses that can be easily sorted?

Why am I having problems installing Megastat on my Excel 2007 Windows Vista? It runs and then it says checking for previous megastat on excel and then the...

Instead of the jobcode being one title, need to break manangement title out to two new columns: Title and Section with title spelled out. Is this...

I have a spreadsheet with extensive calculations, is there any way to speed up the calculation process? -- CK

In Microsoft Word, it is easy to make a shortcut key for each of the four suit symbols. For example, I use Alt+S, Alt+H, Alt+D, and Alt+C to enter suit...

Hi, Say I have 3 columns of data for the Math students in my school: Teacher's Name, Gender, Test Scores. Is there a formula that I can write in a cell that...

hi wonder if you can help me? I am (still) developing our staff timesheets. i have now been asked if it would be possible to add a new function based on our...

I am using Excel 2003. Can I sort a list of numbers by the last four digits? There are apprximately 6 digits in each number.

When I answer yes to save changes in my workbook that I have to edit multiple times per day, it now (all of a sudden) saves my changes to a NEW FILE on my...

I have been using Excel 2007 for a few months now, and am unable to understand why sometimes I get a pre-2007 style Security Notice pop-up asking me to...

Why do I get two versions of the same Excel file (xls:1 and xls:2)? How do I change it back to a normal (without version extension numbers) Excel file? --...

I need a drop down to expedite the entry of info. However, I also need the cell(s) formatted so as to take info not contained in the drop down. How can I...

Column C has about 400 rows of unique numbers that represent locations. 8 other columns (M, Q, T, W, etc.) have numbers that represent contacts at those...

i really need help on this one. i don't know if it's possible but i still want to try. here's the case: A B row8 01- May F row9...