Hi Everybody. I am actually having a problem when i am doing some calculations with cells containing time values. Actually i have 2 cells A and B containing...

I HAVE A FILE THAT I COPIED INTO EXCEL FROM A .LST FILE WHICH I NEED TO CONVERT FROM A SINGLE COLUMN SECTION TO ROWS. I CAN DO THIS USING PASTE SPECIAL HOWEVER...

I am making up a blood count sheet for a diabetic friend of mine. I have times of her counts numbering seven times a day. She may or may not take her count on...

Thanks for th aanswer. I fooled around with the average formula, and it gave me exactly what I needed. If I did not place a count in a cell in ignored that...

How do I calculate feet and inches in Excel?

If I have a range of cells (A1:A10), how do I concatenate only the non-empty cells with carriage returns between each one? Thanks in advance!

As mentioned above, if A1 =$0.09, A2 =$0.05, A3 = -$0.04, A4 =$0.06 I want A3 to be ignored and therefore the formula result should be $0.20

WinXP/Excell 2002 Counta($D:$D) returns 80 but there are 81 noneblank text items! I tried: Counta($D$1:$D$65536) and still get 80. I have gone up and down...

How do I added Sums. ie I have a cell 1 has the formula; =sum (a1:a5). cell 2 has the formula =sum (b1:b5). I want to subtract cell 2 from cell1, but when I...

I have the below If statement, which is working fine expect that when both column K and L = blank (satisfying false criteria) it returns "CCO". If...

I have a dutch version of excel. Now I'm learning to program. I've bought Excel 2003 Power programming with VBA (John Walkenbach). In the instructions in the...

Any way to build boxplot and whisker diagram from pivot table? where can I get this information. Thanks

How do I assign a data entry form to open in a home worksheet rather than the worksheet that contains all the information?

How can i set the "logical test" for an if function to refer to a range of cells. eg. i want to say if(c1=01:021,0,1)but this formula does not work (c1 must...

Hi I need the reference to "Trade Debtors" in the following formula to be linked to another cell :- =SUMIF(L17:L25,"*YTrade Debtors*",R17:R25) I have tried...

I am looking for the formula where I can enter a date and excel will calculate and display all consecutive dates in column form that are...

A long while ago I wrote a program, to determine the winners velocities of pigeon races in basic on an Amstrad , then translated it into qbasic. I am now...

How do I set a max value to a cell. and if the value in that cell exceeds the value. How do I place the remainder in another cell?