I have 3 columns (K, L, M) that we paste text into from other soucres. The text that's pasted is sometime all caps, hence the reason for the "Proper Case"...

I'm trying to figure out the best formula to resolve the following: A B C Name Jan. Feb 1 Barb ...

I am trying to take this formula and move it from on column to another and only change one value. When I go to edit the formula it removes the "{}" around...

Can anyone please help wih a formula to show kid's the beakdown of a currency amount. eg: R35.00 = 1 x R20, 1 x R10 and 1 x R5 R50.00 = 2 x R20 and...

I need to end up with a total of a person's expenses across multiple tabs. I do have a unique identifier. However, each person can only receive $400 from...

I have data that I download into Excel and initials are used for different people. I need to give those initials a number in excel for example MJ = 01, HS =...

I am trying to add a trend line but when I get the droop down box the "Add Trendline" is not highlighted. This is true whether I use the dropo down on the...

I need to flag when two cells don't equal another cell, i.e. S34+V34 must equal Q34 and if it does not, I need to be able to find that error easily..... I...

I am trying to link a cell in one worksheet (sheet 1) to a cell in another worksheet (sheet 2). I put in = then click on sheet 1 tab, then click on the cell...

Using Office 2003. In my weatherstation data, , the wind's direction changes are listed as:- NORTH, NE,SE,SE,EAST,ENE,WSW,SOUTH,SE,EAST, NW, WNW, and so on. I...

I have just done an advanced filter and copied the results to another sheet, the data has been copied over with just values, is there any way of copying the...

Hi, In a table as...

I understand the =transpose(a1:a2) etc function and to create an array etc - however I want to copy data from a different work sheet and transpose it but I...

Is it possible to do the following... Sheet 1 Sheet 2 A B C ...

How can I change the cursor color in Excel? Normally when you stand on any cell, the selected cell shows a black border with a dot in the right bottom. When...

How do I include formulas from source database in the filtered results

See formula below...if it doesn't find any cells that contain "*A", a zero is entered in the cell. I would like the cell to remain blank if nothing is...

Can anyone help me to use functions to solve the following problem:- A B C 1 02/02/2009 XY 200 2 04/05/2009 XX 20000 3 30/06/2009 ...

I'm trying to use the IF function to do the following: IF(C16+C17)*.31600, (C16+C17)*.3, 1600. In English: If the sum of this range times 30% is greater...

I am developing a console application in which I have exported data from dataset to an Excel. I need to adjust the text to fit within the cells without...