My spreadsheet has numbers in cells B2 to B30. I have used a cell pattern color in various cells to identify the cells that I would like to sum. Cell B31...

I would like to use the restrict Pivot Table function but I do not know how to set it up where is the best place to find out a step by step guide. thank...

I need to change a VLOOKUP formula =VLOOKUP(D566,'Master Data'!$A$3:$Y$438,25,FALSE) The 438 should be 1000. Can I change for the whole column or one cell at...

Is there a way to enter subset, union, element symbols in Excel, and if so, how?

Hey guys Hows it going? I really need your help. I am doing some work for my project and cannot seem to figure out how to sort out information in the...

I am taking a finance class and YTM is causing me much grief. Any help would be appreciated.

I have #'s in columns and need to add a prefix to each column, I have about 10k rows

All of the sudden I am not able to do anything in any of my workbooks. I went to where "read only" is and the box is not checked. The "archived" box is...

Greetings Think of several worksheets in the same workbook: MasterList, Cat1, Cat2, Cat3 .... All of these worksheets contain tables with exactly...

Maybe I asked wrong, Example: Beginning balance $600 A B C D 1 Chk # Chk amount Deposit Balance 2...

Can you format a worksheet to hide rows that result in a zero value from a vlookup? For example we have created a report card program and when students don't...

If worksheet 1 has: 1 2 3 A Smith Travel 1 Mar 06 B Jones Off 1 Mar 06 C Smith Off 1 Jun 06 D Jones Travel 1...

Is there a way to freeze both the top and side columns/rows simultaneously?

Hi I have a source spreadsheet which is dynamically linked to a target spreadsheet using paste link option. But all the blanks in the source as are appearing...

Hi everybody, I created a spreadsheet (Office XP) with all my music collection and it includes the time for every tracks. I just can't find the way to format...

I am using the following formula in an excel spreadsheet:- =SUMIF(B3:B158,"east midlands",$C3:$J158) However it only gives me a total for column C and not...

I have a list of decimals ie. Cell B1 = .52399 and I would like to format these cells to view them multiplied by 100000 and converted to Hex. So I have used...

I have checkbook bal;ance in excel column A is Check #, Column B is check amount, Column c is balance. Rather than go down the list of all the checks listed...

I just updated a group of users from Excel XP (2002) to Excel 2003, current service patch. They are running into an issue with Subtotals: Multilevel subtotals...

Is there any function available to convert numbers to words. For Example, if I type "1000", the function should display "One Thousand"