Hey all, I've been trying to think of a way to create a unique invoice number on a worksheet, say , every time it is printed, or saved maybe.. I'm assuming...

We have a sheet of quotes. In one column we record the date if a quote is sold. I want to get a count of the number of sales in a given month. I am trying to...

One way =INDEX($A2:$F2,,MATCH(TRUE,LEN($A2:$F2)0,0)) entered with ctrl + shift & enter copy down 7 rows --

Further to my earlier post, one of the machines is using Office 2002 (XP) it doesn't like the Networkdays function, can anyone assist with a work around,...

I want to see on a graph the results of a formula when one of its variable take all the possible values between of a range of values.

"Single word subjects and anonymous posters" sure takes any enjoyment out of trying to find solutions and posting replies. You can get a free email address...

I thought this was rather simple until I tried to do it. What I want to do is write an If formula that if True, use this SumProduct formula, if false use that...

Could someone give me the formula to enter into a single cell to calculate and add the VAT ie I type 50 answer 58.75

In a cell I have "First Name Last Name" I would like to change this in the cell to "Last Name, First Name".

=3DINDIRECT("B"&A1) HTH Anders Silv=E9n "hevner" skrev i meddelandet = ... =20 ...

I have the function that finds the largest number in a series of numbers....but I want to find the second largest number in the series. What is the...

I am creating a FV of money table; F = (1+r/100)n where n represents number of years; however n is an exponent (ie. to the Nth power) How do I input...

When using text wrap in a cell in Excel, the text entered will wrap properly then suddenly, text will disappear, other text will start appearing in the middle...

Dear all I have a column of cells containing figures and have done a simple autosum at the bottom of the column. However, depending on what the answer is, I...

Hello, Is there a function in Excel to send the total disk space, available disc space, and used disc space from the computer to a cell? I found the info()...

Hello. Here is my problem: In cell G4, I have this formula =+D4*F4. D4 contains the number 356 and cell F4 gets its number from this formula =+B4/E4. G4...

I need to change the number of cells being added depending on the number entered into cell A1. For instance, If cell A1 says 10, I want cell B1 to...

This is probably more info than you need, and I'm sure it's either a simple answer or impossible, but here goes.... I have a workbook with worksheets...

I am having a problem reading values other than the plotted values off the graph. For example: Values plotted for x=30, x=50 are y= 2 and y= 5 respectively but...

I want to be able to type in the follwing in to excel: 001234 0123 12323458 000032 And have the Zeros stay in place and have different length in number- I...