Hi, When I select Calculated Item in Pivot table formula I received an error message saying Multiple data field on the same field are not supported when a...

If I take an Excel file and Save it as a CSV in Excel 2003 the blank rows from the Excel file show up on the CSV as blank rows (no commas show in that...

I've got the following formula to sum referrals received in a particular month. Is it possible to make it specific to the year as well as the...

My office will soon be migrating from Office 2k3 to 2k7. I have a workbook we use A LOT and it is macro filled. It communicates with Access, starts emails in...

I am grading tests done on EXCEL. Several students' answers look almost identical to homweork problems which had been posted online. Using such templates...

In Excel 2003, I was able to remove the query definition once I had imported data from an Access database, by de-selecting the Save Query Definition from...

Hi, hopefully someone can help me with this as I have drawn a blank. I have the following rental costs options on excel A B C D E 1 Street Monthly...

Hi, After installing MS Office 2007 Enterprise on a Vista Pc , a friend of mine gets a message 'Configuring Excel' everytime he opens the application, the...

Please could you assist with a formula to calculate actual time worked for an individual technician? I have a technician time sheet whereby i have a start...

I have created conditional formatting in Excel 2007 to change the colour of text under certain conditions, but the colour AND font change. The font of the...

Dear All, I have exported some data From Tally in which format shows Dr & Cr now i want total seperately of Dr and Cr ( file is attached for reference...

Hi, i have a shared workbook. I want to work with another user, at the same time. But if i enter some datas on the same row as the other user, i receive an...

Is it possible to link to a positive dollar amount and then have Excel automatically convert it in my spreadsheet into its identical but negative value?

Hi I have a spreadsheet with a combo box setup. I want it to display in the pull down dates in the format dd/mm/yy from todays date - 5 days to todays date +...

If I entry Data in A1 & B1 on sheet 1 I want to get Meging data of A1 & B1 in A1 on Sheet 2, eg. Sheet 1 A1 B1 Kolkata 700...

I am looking for a business formula: Basically, I am trying to figure out the best bulk discount per unit as possible to maximize profit. For example: 10...

I have two regions in exact same places of sheet 1 and sheet 2, I want to find all cells in the region in sheet 1, such that the cell content equal to 0, and...

This is happening within an open spreadsheet. Somehow I have accidentally hit something or some combination of keys that makes the cursor "stuck" in...

Having had not much to do - actually nothing with showing a trend on a chart I would like some help. Have setup a chart that shows Name Annual leave...

I have a bunch of names on a spreadsheet and i'm looking for an easy way to replace the names in each cell with a single character, 1, x, etc.