Hi all, I have a sales worksheet that calculates 'action codes'using COUNTIF. That is easy. Is there a way to enter more than one 'action code' in a cell and...

I have two numbers that I need to calculate the percentage of difference between them. Example: $1.22 increased to $1.30 = I need a formula that will tell me ...

I have a workbook that has 10 worksheets. After I select 6 worksheets, I am trying to find a way to have each worksheet saved as a separate workbook. Thank...

I've written a macro that opens a txt file as space delimited, copies it into an xls workbook, and then moves the data from the txt sheet to an xls sheet. ...

I would like to know how to protect a worksheet with "read only/view" capability. I am able to password protect the worksheet, however other users cannot view...

"Stewy p" wrote... I need help in looking up the a table that is sorted by product and by dept and date. (In my actual...

Ok, I have a VLOOKUP function that works, but here's what is weird. It's giving me all 0's. When I go and double click the cell that contains the lookup value...

i have given some conditional format to the cell. which have red, green & black colour. Can it count the cell how much cell in red colour & green &...

I am using an array formula to pull a range of values off of Sheet1. The values represent a continuous measure, in this case, minutes. I'd like to know what...

Here's another option for your nested if statement. I have set up this formula to give you a zero if the value is below 10 and that's why you see the zero...

Try this instead Jim =IF(A1="","",LOOKUP(A1,{0;7;12},{7;12;17})) note that if A1 is 17 it will still return 17, if you want blank if greater than...

Hi All I have a work sheet best decribed as a timesheet. I also have two columns e.g. A and B containing Names (A) and Pay numbers (B).In Cell C1 I have a Data...

How do you search through an entire worksheet (the formula resides in another worksheet) to find the largest number with the MAX function? Thanks.

Good morning... I have a workbook that I have saved as a manual calculation which does NOT save before closing. I had to set it up this way because I have SO...

I HAVE A LIST OF NUMBERS IN COLUMN A. I HAVE A NUMBER THAT IS EQUAL TO THE SUM OF 2 OR MORE OF THE NUMBERS IN COLUMN A. CAN I FORMULATE ANYTHING TO RETRIEVE...

The Office 2003 Student/Teacher upgrade does not appear to have an xirr function. Is this seperate function available as a download or do I have to purchase...

I know this is simple but I don't have a resource for commands such as "end down",etc. anyways, if I want a macro to include only the data I've entered and...

I have just been browsing the web site and come across some very useful tips and tools. One of those was linking cells together.Depending what you select from...

how to you right not equl ina formaul for ex, if A2 is not equal to 0 than hello

Why wouldn't this formula work? The value of A6 is Oct. What I am trying to do is summarize on my 'Summary' page some transactions by month. The dates for...