I am creating a home building estimate program in excel and want to return the value in a certain cell by giving row and column referances. I created lists...

Hi I use WinXP with Excel 2000 I use a "helper" column in a linked spread sheet with approx 1200 lines of data that is then used to generate a pivot...

Hi, I created an index sheet and I would like to point at it when starting up the file. Can it be done on off07? TIA Mike

Hey guys would really love some help. I am putting a list of the best movies of all time together in my spare time. I have movie name - year of release -...

I have a work sheet with 6 columns the headers of the columns are A=Class Codes,B-F are years 2008,2007,2006etc. can i have excell put a value in a cell as...

I would like a macro to do the following: I would place the the cursor in any cell and this macro would give me the average of all the entries to the left if...

You could use MATCH Eg assuming the years (2008, 2007, etc) are numbers entered in B1 across then in say, A20: =MATCH(2008,$1:$1,0) will return the col number...

This should be really easy, but I am very elementary with formulas. I can add and subtract two numbers basically. Okay, I made a spreadsheet to figure...

Hi doing my cert 2 and i am stuck on 1 formula i need to work out the total cost of something where the first 1000 are $0.50 and anything over 1000 is $0.40...

Hi Ron, CLEAN would remove any "endline" thingies inserted with ALT+Enter at the end of each text which XL may be responding to. But if the issue is as you...

I was working on a spreadsheet in Excel 2007 that I had previously created in Excel 2003. When I edited the header in page layout and switch back to normal...

Greetings, again. I hope I'm not getting too annoying by posting so often, but I can't solve this problem on my own. I am using MS Excel 2007. I have a...

I have been doing a lot of reading on this function and can usually get it to work to do the job - not overly complex. One thing that is still not understood...

I have a spread sheet of 100 rows & 60 columns Bottom row is years 2008 thru 2068 -- Range A1:BH100 Columns have numbers scattered randomly. Most numbers are...

is it possible to automatically link excel and word (i currently use excel 2003) so that when i input a figure in to excel it automatically replicates itself...

Hi, Excel 2 Word 2 OE 2 Mail Merge I am not good at clearly explaining myself or anyone else's self. I use Office 2007 Proff but not as a pro ( NOVICE...

Hyperlink to url returns error. Hyperlink is valid; error is valid but stops the program. Link is in a loop so I want the loop to go on to the next input...

Here's what I have: A1 = .75 (that's point seventy-five, less than zero) B1 = the argument =IF(A10,A1,0) The result I get in B1 is 0 when it should get the...

Does anyone know if it is possible to remove an autoformat from a pivot table once the document is saved? I would like to return the pivot table to its...

Hello, I was trying to use sumproduct to calculate if column a was a date and column b was item and column c was a dollar amount so I would know how many...