| Thread | Last Post | Replies |
|
| How to put a formula in a column | 25 Aug 2008 18:06 GMT | 6 |
the formula a1*b1 is in C1 and i need to place that same formula in every cell in the c column example: a200*b200 in c200 (the information in each cell is different) I just don't want to put the formula in each cell help
|
| How do I disable a SORT | 25 Aug 2008 17:58 GMT | 4 |
I opened up a previous Excel doc and it was inexplicably sorted by the data in one particular column. I don't want any sorting at all on the document, yet when I go to Data > sort > none, it returns an error message saying that the field cannot be none. How can I take OFF the ...
|
| Help needed with cell reference | 25 Aug 2008 17:41 GMT | 6 |
I am trying to piece together info from three cells in an effort to reference another cell. EXAMPLE A1 = 2008 (This is a hyperlink that links to worksheet('2008')
|
| I want to create a calculated item based on a calculated field | 25 Aug 2008 17:30 GMT | 1 |
Dear I want to create a pivot table as below to compare sales numbers by product with 2 years in the columns, and for each year the kg sold, the margin and the margin/kg. Furthermore I want to calculate the difference between the 2
|
| Group cells during sort | 25 Aug 2008 16:48 GMT | 1 |
I have a sheet that has column A marked with a priority level. A, B, C and so on down the sheet. Across from that I have colum B with the project it applies too. In column C I have the details of each project listed down about 4 cells
|
| Remove Email View on spreadsheet | 25 Aug 2008 16:21 GMT | 1 |
This is such an easy questions no one has asked it on this board. My predessessor created a spreadsheet which shows an email address (like Outlook) at the top of the page. I can't figure out how to take it off. Any ideas? This is driving me crazy especially because when I hear ...
|
| How to list items instead of counting them with Pivot Table | 25 Aug 2008 15:42 GMT | 2 |
Under Excel 2003, I have a worksheet with several columns. When using the Pivot Table I am able to select count, sum... possibility for the data part of the Pivot Table Layout Wizard. It works great and I am happy. However, I would like now to list the items instead. How can I do ...
|
| Adding columns | 25 Aug 2008 15:42 GMT | 1 |
my problem is my totals on my invoice are cents off. Some totals are right to the penny, while others are short by several cents.
|
| Copy from one sheet to another using VBA | 25 Aug 2008 14:54 GMT | 2 |
Hello I am currently retreivng a list to which I add a sequence number and from which Max() gives me the last record in the list. Name Country Code Amount Sno Mr x MRU M01 10.00 1
|
| Find and Replace Troubleshoot | 25 Aug 2008 14:40 GMT | 6 |
When I find and replace using an *, it replaces the actual text with an * instead of replacing with the text that is already there. I can't figure out what I am doing wrong. Cell= 22-SRH059
|
| Excel 2002: Max, Min and Average formulas | 25 Aug 2008 14:32 GMT | 3 |
I need to compute the average, maximum and minimum values fore items with identical codes as illustrated below: A B C D E 1 Code Weight Average Max Min
|
| If(and statements using data in an array | 25 Aug 2008 14:30 GMT | 5 |
I would love some help with the following statement. {=if(and(b2='DBP - 09'!D:D,C2='DBP - 09'!E:E),'DBP - 09'!K:K,0)}. I've previously used excel 97 and am now using excel2000, so not sure if something has changed from that version to this. The formula returns a #Num error. ...
|
| Excel 2002: How to compute average, min and max figures? | 25 Aug 2008 14:30 GMT | 3 |
I need to compute the average , maximum and minimum price in Table 2 from raw data in Table 1: Table 1 A B C D
|
| Validation Problem | 25 Aug 2008 13:50 GMT | 3 |
To simplify the spreadsheet, I have Users listed across Row1 from B to G; and Activities listed down ColumnA. Each User has to enter their time against an Activity. The total time allowed for all Users per Activity is shown in ColumnH.
|
| why would a excel file sent with data open as grey screen | 25 Aug 2008 13:15 GMT | 1 |
Sent a excel file (.xls) containing data via email. Other contact opened file sent and stated it opens as a grey screen, contains no data. This file is updated and sent on a weekly basis, and this week he cannot successfully open file.
|