I have a huge spreadsheet that I am typing dates into from past years. Is there an easy way to tell certain cells that they are 2003 or 2004 so when for...

Please help on this: I have 5 colomn with 6 row with number 1 or 0 A B C D E 0 1 0 1 1 1 0 0 1 1 1 1 1 ...

I want to calculate the average of non-adjacent cells (ie "=average(A3, D3, G3, J3)"). In some cases there are blank cells in the set. How do I prevent...

Can anyone help??? I have been tasked to write a macro that will take one worksheet and split it up into multiple sheets. I have found wonderful information...

Hi 1.In all my summary sheets I have the formulas like =IF(INDIRECT("'"&(C1)&"'!c91")="",NA(),INDIRECT("'"&(C1)&"'!c91")) This works fine and returns #n/a...

how to return a date to YYQN (eg 08Q1, 08Q2)? thanks

I posted a several question time ago, then I abandoned the problem, now I had to go back to it again Sheet 1: I have a big table with 100 countries in column...

In any cell of column C of Sheet 2, I want it to return the last non-blank cell from Sheet 1 Column D...being the last non-blank cell in or ABOVE that row. ...

I´m able to find a specific phrase in a string. But when this is a number the result is still a text cel. What is the worksheet function I can use to...

We have approximately 5 Analysis Services cubes that we deliver with our product that we want to build some predefined pivot tables and graphs in Excel that...

I would need the German versions of the US keyboard shortcuts - most of all of the US CTRL+[ and I can't find anywhere such correspondence list

Is there a way to have a formula contain something like this: =100+200+value("The second number came from xyz") and have the formula just equal the 300. ...

Is it possible to use countif to count the number of times a certain number appears in column A, C, E...etc through to W, but ignoring columns B, D, F, etc...

I'm comparing 2 lists of serial numbers. The first list is smaller. The 2nd list is more extensive and contains information in 3 more columns that needs to...

'=IF(AND(B2:B5=A1,C2:C5="WEEK1"),VLOOKUP(C10,$B$2:$D$5,3,FALSE),"") - this formula gives me a #VALUE error. A1 = 10 A2 = 11 col B col C Col...

I have two worksheets of data. The 1st (Fuel) contains the following headings: Date | Econ | Dist | Cost per | Total $ The 2nd (Service) contains: Date |...

Hello, How do I write a function that adds the values for the intersection between row 12 and every 7th column (to give a concrete example) . To...

I know the lengths, and I know its a TAN function but I cant see how to actually write the formulae to solve it I'm using Excel 2003, and I've converted the...

I created a form in Excel with a Vlookup when a site is selected the e mail address is displayed in a cell. I now want to add the ability to by clicking on a...

I have an existing excel worksheet with several numbers, subtotals, etc that are all stated in whole numbers such as $1,245,789. I would like to state all...