| Thread | Last Post | Replies |
|
| User Form - how to load it | 20 May 2008 12:39 GMT | 4 |
I have developed a user form. How to ensure that it gets loaded when ever I open the workbook ?
|
| How Do I change repeating numbers in a column | 20 May 2008 12:06 GMT | 7 |
Hi, I'm creating a huge spreadtsheet for a large music collection. One of the columns is the track number. Unfortunately some of the discs have the same track number. I would like to figure out a way to index these numbers so
|
| How to make a worksheet unchangeable by other users | 20 May 2008 12:05 GMT | 3 |
I want to place an Excel sheet on a shared drive for others to see but I don't want them to be able to alter or input any data
|
| Invisible sheets | 20 May 2008 10:53 GMT | 2 |
I have received an excel file with vba and it has the code which prevents the file to display most sheets. Is there any way (user level) other than deleting or commenting that section of code to display the sheets? Thank you.
|
| sumif with two different terms | 20 May 2008 10:39 GMT | 1 |
Hi I want to sum column D if column a=x and colum b=y (both terms in columns a & b must be fulfilled) I nortmally use sumif but then i can only have one term, now i want two different, what formula should I use then?
|
| IF AND OR BUT NOT SURE | 20 May 2008 09:46 GMT | 2 |
Not sure how to compile the formula to make this happen: If cell A1 is TRUE then cell A3 =”X”, or if cell A2 is TRUE then cell A3=”Y” if both cells A1 and A2 are FALSE then cell A3="Z" Any help would be appreciated.
|
| Counting colored cells | 20 May 2008 08:33 GMT | 2 |
Is there a method for counting only cells of a certain color?
|
| I need the cells to change based on age of date. | 20 May 2008 06:21 GMT | 2 |
I have a range of dates "=$B$2:$Q$41" that I need to have the cells change to green if the date is less than 6 months old, yellow if between 6 months and 360 days, and red if anything older than 360 days. I appreciate any help I can get. I am using Excel 2007.
|
| Creating a histogram and line on the same chart | 20 May 2008 04:58 GMT | 1 |
Is it possible to have a histogram that represents quantities of a particular subject with the y-axis representing the numerical value and above the histograms is a line exhibiting the cost in dollars of each the histogram subjects?
|
| Excel Changes My Last Digit to Zero | 20 May 2008 03:29 GMT | 1 |
My question is 2-part; 1. How do I change a column containing 4-digit numbers that were entered as text, AND keep a zero in place if it's the first digit? 2. I'm creating what I thought was a simple spreadsheet. Nothing fancy. One
|
| Dates in Excel | 20 May 2008 01:19 GMT | 2 |
I am entering past dates in Excel. When I enter a different month & day but same year in the next row, is there a way to do that without having to enter the year?
|
| Record keeping of points, etc. | 20 May 2008 01:11 GMT | 3 |
We run a small association; anyone have any suggestions on how to set up a sheet where after each event, rather than having to manually enter all points and money from the event making it flow through to the correct places? We keep a point total and money total for year end finals ...
|
| Label printing | 20 May 2008 01:10 GMT | 1 |
How do I change the text size and alignment of one line only when priting labels
|
| Lost files / data | 20 May 2008 01:08 GMT | 3 |
I am using Excel 2003 on MSXP. I have a file for tax records opening a new worksheet for each new tax period. I input data over two days on a new worksheet no problems. I have auto save every 10 minutes activated. A few days later I cannot find the data - completely gone and file ...
|
| pounds and pisters | 20 May 2008 00:58 GMT | 4 |
i want to make separated cells for pounds and pisters and sum the total of them.If pisters more than or equal 100 pisters, the integers automatically add to the sum of pounds.
|