I am new to SQL and using MS Query in Excel to extract data from SQL Server. The query retrives result from a number of tables and the result is in the...

Dear All, I have 30 sheets, which contains the count of SMS of everyday, I need summary on last sheet that every sim consumed how many SMS. The count is in...

How to write the SUM of two MAX numbers in four or more than four cells like there are Five tests out of which only Maximum two are selected for final Result...

Is there any way to make cell editing work like it does when you hit F2 by default? If you just start typing in a cell and then want to use the standard...

Is there any way to link two separate Excel tables so that the data flows between the tables and sorts as if the two were just one table? We have worksheets...

hello, How do I add 1 calendar month to a date, regardless of the number of days in the month? Thanks KK

The answer to my question has probably already been answered but I am in rather a hurry and don't have time to go through all the various threads to find it....

I am a new user of Excel 2007 and have previously used Excel 2002. I have received an Excel sheet which opens in "Compatibility mode" and as "Read only"....

I have a pivot table. The columns are month and rows are sales people. I want to display the grand total for the current month from the pivot table in another...

I forgot to mention that the xldynamic site is back up, I have resolved my host provider. I still have to fix the downloads, but eveything else should be...

Hi, I’m having problems finding a way to auto copy rows of data from one worksheet to another depending on a date entry within the data row. I’ve created...

greetings......i have a row in which if say a4 contains the word help, then all that row is in red text, othewise it is in black text a1 a2 ...

Suddenly, my QuickBooks program no longer allows me to export to Excel. Worked fine a week ago. I can log onto QB from every other pc in the office, and...

i have preset option to put on a cell .. and i need to put more options to choose from .... its tell inme that is invalid .. how can i bypass that or edit...

hi all, I need to compare two excel sheets(sheet1,sheet2) where in i have the employee hours worked for a fortnight. One sheet is generated using an exe file...

I have been searching for a formula to help me find the last time (most recent) color 36 appears in a column of colored cells. Most of the time there is no...

I have a large spreadsheet that I am trying to modify a formula in. Whenever I make any change to the formula, rather than returning the result in the cell,...

I want to email a spreadsheet of mine to my email box, but I keep getting a popup saying "No profiles have been created. To create a new profile, use the...

This is Microsoft Office 2003. I'm typing out end-of-year audit for accountant. sometimes when I type in a number in the column,it changes to bold...

Dear In A1 Customer Name In B1 Complaint Date In c1 Complaint Time in D1 Complaint Attend Date In E1 Complaint Attend Time. I want the Result in F1 Total...