I have 2 columns and I am trying to create a validation in which my 2nd column relies on the input of the 1st. That's fine. But, I need to do a lookup in two...

Hi: I recently setup a spreadsheet with multiple pages that has certain fields locked that should not be changed and certain fields unlocked that will have...

How can I hide a comment by user, if possible? If this is not possible, how can I effectively place a discussion within a worksheet that can be limited by...

I got a cell A1 with a now function =now() which gives the current time. Cell A2 has a time that is entered, and cell A3 has an if function that compared...

Is there one formula that will do the following? A1:A3 = 7/9/2007 AND column C1:C3 =IN, then count (ADD) B1:B3 BUT if column C1:C3 = DD then subtract from the...

How do I find the logarithm of a negative number without having error message

That did it! Many thanks!

Hi, trying to figure out a formula to populate column c, where it would reflect the week of the month. This would be calculated off the value in column A....

I need help. I want my formulas to have name cell but not sure how to do this. The formula is: =LOOKUP(C22,Suppliers!$D$5:$E$8,Suppliers!$E$5:$E$8*'Summary...

I need a formula to pull only numbers and one to pull oinly letters from a cell and put them in another cell. Scenario: Worksheet A, Cell A2= (7) apples I...

I have a large worksheet that I need intact. I want to save a small section of it as a separate file. Can I do that in Excel 2003?

when i am open workbook directly from icon or excel file i cant it is hiden but i cant open it from tool bar open button(with path)

Here is a formula that I have working (it is long with lots of IFs and repeated many times in my...

When I put a number ex. (14) into a cell , then click to another cell the number 14 changes to a .01. Any number I put in then click out of that cell the...

Hi, Can u pls help me regarding Sum If, in sheet1 we have code and amt , we need result in sheet2 with A2 column reference sum of code value. In Sheet 1

I am to begin calculating rep commissions in the coming months based on a "tiered" or "step" method. The rep commissions will be based on YTD sales and their...

I have 1000+ records over 4 years & want to count how many for each month & year ie May 2005. Records have specific days 4 May 2005 I can use...

Can you explain to me what the function is of the $ signs in the formula below? =MIN($H$2,H4)

Hi, I have data as below and would like to know how to use a INDEX/MATCH to get the summary captured in the summary below A BOM 1 A BOM 2 A ...

How can I protect range of cells in a worksheet - Thanks