1 case equel to 12 packets. In my system shows 215 case and 11 packet. My hand i have 247 case and 9 packets. How i can make a excel formula and result should...

Hello, i have extracted text within texts in a column of data thru left & right function. then i have the texts result like this 26.04.09 11.06.09 23.06.09

I use excel quite a bit. It has always been great, but recently, and without any intervantion on my part, in excel 2007 the numbers I type are automatically...

I want to make an invoice template in Excel, to take advantage of the ability to calculate time, rate, total, etc. When I download a template off the MS...

I am using Excel 2003 and have formatted cells to display € in an existing workbook but all I get is a vertical line. However, if I format cells in a new...

Hi all, Of sheet 1, rows 2 tot 252 and columns A to AR I want to copy columns A to C to sheet 2 colums A to C rows 2 and further, column D to sheet 2...

How do I do this? My Cell B1 contains the number 55. I want my textbox to read "Cell B1 is 55", But HOW???????????

I have 2 files, File2 gets data from File1. I used a formula in file2 =X:\Folder\Totals'!$D$2. If both files are open on the same computer, File2 updates...

Hi, i have dates in range A1:L1. In range A2:L2 i will have numbers. If A2:L2 is empty, then the code to display content of A1. If A2 has some numbers, then...

One of the cells I wish to sum is a formula and does not sum. Thank you.

In a worksheet there at least a 1000 cells containing the formula = Cell reference*6.23 where cell reference is A1 , A2 , A3 etc. I wish to change the...

I am counting cells with multiple criteria with the SUMPRODUCT function. What I would like to do is have the function's 2nd range change as the current...

Hi, pls could some-one advise me on a book, web-site in order to learn how to use Macro's, but as I have never used them before it really needs to be the...

How do I exempt the 1st row from sorting?

I need to find quantity of Letters between some period of time (one week) from 21-09-09 until 27-09-09, which are not replied (Cells with Reply date are...

I’ve been able to change the function keys in Word and assigned them to different macros that I use often, but I haven’t been able to do the same in Excel. ...

In the older versions of Excel you could select the Web toolbar & it would show the file location/path.

I need to find quantity of invoices between some period of time (one week) from 21-09-09 until 27-09-09 invoice_No date I-1245 ...

Hi, i have this code: {=IF(NOT(SUMPRODUCT(--(Sheet1!A2:L2=TODAY()),--(Sheet1!A3:L3""))),"Please...

Thus end row can auto change to the last row? like...