Hello, In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case...

I have a list of items in excel that belong to certain groups. (see below) --Sheet 1-- A B 1 Electrical 3.1.1 2 Electrical ...

I have an address list in one worksheet. I have a form in another worksheet where I want to place a combo box that will allow me to select the person's name...

Here's my functional formula =IF(OR(O13=1,O14=1,O15=1,O16=1,O17=1,O18=1),"Need to answer all...

I want to how to put a formula for the beow requirement. sum of two cells, if i get a postive asnswer I want to display it, if I get a negative answer i...

I have two tables. On one table i have an income $ amount and a corresponding state. In the second table I have a list of states and their respective income...

I'd like to use a named range of "FactorA" (which contains multiple cells), etc, and I'm trying to do something like this =AVERAGE(IF(INDIRECT("Factor"...

I have a long list of names and associated data contained in one worksheet. On another worksheet, I have created a form that loads the pertinent data...

I'm creating a worksheet to calculate money.. If the amount is negative I want Excel to display the number in 'Red'.. If Positive I want to have Excel...

Hi, I downloaded an excel spreadsheet from a website. Column A:B on the spreadsheet is a reference for my vlookup formula in another worksheet. The cell...

I have the following data in 3 columns A B C TOP BULB 1 TOP SCREW 5 TOP LIGHT 1 TOP LAMP 1 TOP PAPER 1 BOTTOM BULB 5 BOTTOM SCREW 4

I am trying to save data in target worksheets based on column value of cell found in source(Master) spreadsheet. I know I can consolidate several...

Hello, A B C 1 Name Address Ph.no 2 xyz xyz 2357226, 3 abc abc ...

I have an issue with sum formulas not updating for new info in the range cells? It looks PC specific, but I don't know how to check the problem. Ant help...

In one section of my form there are 2 columns: A and B. Cell range B1:B7 contains a series of different numerical values associated with the corresponding...

Hi, I have the following challenge: In my teaching a have to count the number of hours students spend on their extra curricular activities. This is the table...

On Sheet 1, I have a listing of stores. I have an auto filter on there so I can filter by Account name and get back a listing of stores. I'm using the the...

Hi, I would like to perform a TTEST on a set of data that is spread over many ranges. I cannot sort this data as it is already used for a chart. I tried...

I need some hel. I have three columns of data in a worksheet. Column A contains the names of people. Each person's name may appear multiple times in column...