Hello, I have a listbox that when selected, update the pivot table (change the variable pivot field called "Machine") based on the selection on the listbox....

When changing the cell to accounting format all 0 (zero) values change to - Are there more options available, in particular I would like it if 0 (zero) would...

Need formula to average column of numbers as is, and as they will be as I sort by using the Filter. I can do this for total counts using the...

I would like to apply a conditional format in a row, where the first condition is that the value be greater than the cell on the left AND equal to the one on...

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...

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 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...

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 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...

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 am using Excel 2003. Can I sort a list of numbers by the last four digits? There are apprximately 6 digits in each number.

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...

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...

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...

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

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...

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...

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?

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...

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...