| Thread | Last Post | Replies |
|
| Rounding up results | 10 Aug 2006 16:25 GMT | 4 |
Have problem rouinding up result: Some calculation, the worksheet last column contain the following formulas, from top to bottom: =E17*F17 =E18*F18
|
| Header Footer on multiple worksheets | 10 Aug 2006 16:11 GMT | 1 |
Is there anyway to have the same header/footer print across an entire workbook (ie multiple worksheets) without using the custom header footer on each worksheet within the file? Thanks
|
| Splitting columns | 10 Aug 2006 16:10 GMT | 1 |
I am stuck for an answer here, so any help is appreciated. What I'm trying to do is take two columns, sort them and then break those two columns into four columns to fill the whole page while still maintaining alphabetical order.
|
| adding totals... more complex than it sounds.. | 10 Aug 2006 16:03 GMT | 5 |
i have a table, i have a column of cells containing the values 'k' or 's' or 't' or 'r' i then have a column of cells containing a sum of money representing a figure 'k' has achieved on that particular row of cells etc.
|
| clarification: cumulative to-date total formula needed | 10 Aug 2006 14:48 GMT | 2 |
I am trying to create a forumula that will give a cumulative or "to-date" total that will exclude future months from the total. i.e. ithe point in time is august and I need to show a to-date number through august only even though september and october are included in
|
| View only Highlighted Cells | 10 Aug 2006 14:33 GMT | 5 |
I have highlighted some random cells in a 3 columns. Now what should I do to view only the highlighted cells separately? Please help.
 Signature sreekanths22
|
| i need to make a tally | 10 Aug 2006 14:31 GMT | 1 |
i have a table that has cells in colimns that display letters, for every 'k' i need to add 1 to a total
|
| 2 versions of same file opened at once | 10 Aug 2006 13:58 GMT | 2 |
I have an abc.xls file. When double-clicking on this filename, the fil opens twice in Excel. Once as abc.xls:1 and once as abc.xls:2 Also when I open the file from within Excel, it opens 2 versions.
|
| Drop down bar to hide column according to the content of a cell | 10 Aug 2006 13:36 GMT | 5 |
I need help. How can i write a macro such that when the user select (e.g. 2 ) from the dropdown for, it hides column G:Z when the user select (e.g. 5) from the dropdown form, it hides Column
|
| blank fields become "0" | 10 Aug 2006 13:26 GMT | 3 |
if I "duplicate" value from one sheet to other by "=Sheet1!A6", blank fields on Sheet1 show up as "0" on Sheet2? How can I fix this? regards, D
|
| I Need Help! Asap. | 10 Aug 2006 13:22 GMT | 6 |
I am trying to create a quote sheet. I have located similar information however it doesn't make sense. tried to used nested IF statements but the limit of 7 doesn't work ou very well. Then I tried to explore Macros but I have no idea how thos
|
| New | 10 Aug 2006 13:16 GMT | 1 |
Im just curious, Im somewhat new to Excel. I am starting to do stock market trades. For Tax purposes, I have to report my cost - and the Revenue gained so that I can be taxed on only the profit. Not only that, I have to report if it is
|
| Data>Validation>List - Unique Entries | 10 Aug 2006 11:54 GMT | 2 |
Hello! Friends I have a list of names containing duplicate names and empty cells. Using Data > Validation > List I want get a drop down list of unique entries having no empty cells.
|
| printing labels from an excel file | 10 Aug 2006 10:26 GMT | 1 |
hi, i need some help. i have an excel file that i need to convert into labels to put on envelopes. in the first colum i have first names, second column last names, third
|
| Lookup and fetch from the same column | 10 Aug 2006 09:53 GMT | 1 |
I have spread sheet that has three columns, out of which two are pr populated and I am finding the information for the third column fro the other system.
|