General

Cell Formula
I need an Excel 2003 formula: If the first cell contains the letter Y then a second cell will display a name contained in a third cell - The second cell needs the formula. ... 12 Apr 2010 19:16

Pulling data from other spreadsheets
I'll try to explain as best as I can. I have over ten spreadsheets in reality but for this example, lets just say that I have two. Alpha and Beta. I am trying to put together one workbook that pulls data from both alpha and beta so that I can review without having to open them both up. The first tab in this ne... 12 Apr 2010 19:16

Command botton
I need help with Excel 2003. I have different conditional formatting in columns A through S. I've intentionally left row 2 blank. What I am trying to do is input additional info into row 2 and have it auto sort that info into the rest of the sheet according to column “B” which is alphabetically sorted. ... 13 Apr 2010 18:30

showing 2 numbers in a cell
I think I have seen an example where you have 2 seperate pieces of information in a single cell. I run a hockey team and use excell to track players and who is available for matches and then who's played....really basic stuff. But I would like to also record in the cell if anyone scored and if so how many. So i... 12 Apr 2010 22:34

Can I put hyperlink to an email in a cell?
I currently cut & paste email details into the 'comments' part of the cell but I would prefer to paste a link to the real email into the cell itself....so that it brings up the actual email if you click the cell....obvioulsy then you don't have to go and find the original etc. to be able to reply. Is this poss... 12 Apr 2010 18:09

Multiple Pivot Tables based on the same data
I have two pivot tables based on the same source. However, each table is unique in how it shows the date. The first shows all thirty days of the month. The second groups the date in 10 day increments. The first table is summed data while the other is averaged data. When I try to set up the second table to gr... 13 Apr 2010 12:50

Excel Cell Compares
I have an Excel spreadsheet with 30 rows in it. I need to write a formula or macro that will compare the value of cell C1 to C2. If the value is the same then I need it to look at cells E1 and E2 to see if the value of either is ZZ. If the value is NOT ZZ then I need it compare cells C2 to C3 etc to the bottom o... 12 Apr 2010 15:55

Please help to get cross reference with another sheet
I have a column with name 'Item' which contain the code of the product. Another sheet ( same file) contain code and profit. Sheet1 item A1 200 300 400 500 600 Sheet2 Item preofit A1 B1 200 60 500 10 600 20 400 10 I have to fi... 12 Apr 2010 17:03

Convert FUMIFS to a format useable in Excel 2003
I have the following formula SUMIFS(Costs!$E$22:$E$60,Costs!$D$22:$D$60,Summary!$A7,Costs!$C$22:$C$60,Summary!D$3) , used in an Excel 2007 spreadsheet. I'm trying to rewrite it as a SUMPRODUCT of SUMIF with no luck. Can anyone steer me in the right direction? ... 12 Apr 2010 15:55

Show Pivot Table Dates in a Month/Year Linear Fashion
Hello, Is there a way to show dates in an Excel 2007 Pivot table in a Month/Year Linear fashion? Any help/suggestions will be greatly appreciated. ... 12 Apr 2010 19:16