I have 4 columns that I am concerned with. Say F6 is a fixed number, column G & H are Yes and No columns. Column I6 could change. I want my formula to see...

Thanks for taking the time to read my question. I have a list of computer models and I'd like to have totals at the bottom of each kind using a formula. ...

Hello, I have an application in which I'd like to match up data from two large spreadsheets, lists of addresses. One of the lookup variables, a customer...

Does anyone know how to correct this error short of reformatting and starting over?

I have a cell where I need to keep the amounts separate to show workings out, but I need this to be then added up in a sum, is there a way to do this as at...

Here's all the relevant information: a) I was able to successfully create a pivot table, in a newly created tab named "Sheet2". This pivot table is contained...

I have a table containg start dates in column a and end dates in column b. The start date for the second (and subsequent) record is the end date for the...

I have users input number of hours for a particular month/day, and it updates a table in another sheet...this works fine, until...the user changes days, and...

I have an excel sheet used for entering data, I am now hoping to expand the sheet to use as a database so everytime i add a new result i can add it to my...

In older versions you could use AS after the field name and replace the name, now that doesn't work. Example would be select dwdata.lstnme AS "Last". With...

I want to use the following formula in cell B3: =(A3*(C29+3))-B29 However, I want to drag this formula down column B, but keep "(C29+3))-B29" constant. I...

Hello Regular Registration Ends This Weekend. Atlantic City, New Jersey will once again host the Microsoft Excel / Access User Conference (Trump Taj Mahal)...

Can anyone tell me how to get the match and index functions to work for an 8x8 table? So for example I would like the function to take a given text string ec...

I have a date range in columns A and B then a number in column C: 05-Jan-09 09-Feb-09 100.00 10-Feb-09 25-Mar-09 200.00 26-Mar-09 11-Apr-09 ...

Hi, I have a set of data in time format as such... 0:10:38 0:10:36 0:08:57 0:31:44 0:30:39 0:29:19

Hi everyone, Could anyone help and tell me what's the matter with this please? =if(p1:p4,"",AVERAGE(IF(P1:P40,P1:P4,FALSE)) Scratching my head - feels...

The formula on the E1 is =LOOKUP(2,1/(A1:A20=D1),B1:B20) A B C D E Bill Science Bill Bill ...

The formula on the E1 is =LOOKUP(2,1/(A1:A20=D1),B1:B20), but it only shows the last cell (on the B column) of the same item on the E column ...

I finally found out (thanks to all you helpful folks!) how to get a drawing object or text box to display the contents of a cell. Now, I need the opposite......

Hi Using only worksheet functions, how do I find out if a row is hidden? Thanks.