Here's a weird one. I have a spreadsheet that was sent to me that contains numbers as text containing dashes(-). Normally I can remove the dashes to create a...

When multiple feilds are placed in the Values window of the pivot table setup screen, the resulting data is stacked in one column. Can this data be spread...

Is there a way to filter for the highest value in a list of records? For instance if I have the following table: Column X Column Y a 1 a 2 a 3 a 4 a 5

MS Net Framework is a real compatibility issue with Excel 2007 - causing significant problems with the copy - paste function - one problem with excel 2007...

I have formatted a cell for a date format and I've selected it to show 12/10/08 but when I type today's date as 121008 it shows 4/22/31! I've tried this...

Hi, I'm looking for a way to create a spreadsheet that will dynamically track historical stock prices over time using a web data source; is there any way to...

Hi I'm trying to import xml data into my excel workbook using a stylesheet. When I open my xml file I'm allowed to pick my stylesheet and the data imports...

How does one restrict certain characters from being entered into a user form TextBox?

excell de bir listeyi copy paste yapıyorum ama bazı satırlarda yazan cümlelerden üçer dörder tane satır var tek tek silmek yerine aynı olan...

I was wodering if I could get a free excel file that has a simple PERFORMA. For instance, If I bought a motorcycle at $1,000 for $100 payment a month, that...

Excel2003 ... I have a list of numbers which may repeat a random # of times. The numbers are sorted in Ascending order. Each time the number chgs I wish...

Does anyone know of a data connection available to pull quarterly investment results from an internet source into Excel 2007? I am looking for a solution...

I am trying to do a Vlookup using time. Whenever I reference the cell in the formula that contains the time I want to look up, it converts the time into a...

When I close out of spreadsheets in Excel 2007, I am sometimes prompted with the "Do you want to save" question, but sometimes I'm not. I want to have this...

I have about 65 worksheets in a workbook that record an employees time/activities. A particular code is given per activity per line. Times are calculated...

Need this right away for a job. HELP!

Hi, I have a chart which I am struggling with, I can usually do dual axis charts but this wont let me. Below is the data I am trying to plot. I would like...

When I copy & paste a formula in excel the formula copies but does not work. eg. =SUM(F16:F18) is copied from =SUM(E16:E18) but the total is the same as the...

Excel 2003 dilema. Worksheet one needs a formula that will pull the contents of a cell in worksheet 2 AND a separate workbook. The contents of the cell in...

I'm developing a macro to create buttons and want to feed the process with variables for placement and size. I'm using this...