| Thread | Last Post | Replies |
|
| Any way to freeze cell format? borders, shadding, fonts ... | 20 Feb 2008 04:12 GMT | 2 |
I often make nice borders, with fonts and shading. And i have data inside this chart. Then sure enough, I end up needing to change all kind of data, and move the data to different columns and rows. when a move a cell it it also move the border and any other formating. So
|
| SUMIF help and another query | 20 Feb 2008 02:21 GMT | 2 |
I'm wondering if someone could help with a problem I am having - not so much a problem - more I'm not as good at Excel as others here and they may be able to help. I'm treasurer of a semi-professional non-league football club. As such I
|
| How to get cell input to access list? | 20 Feb 2008 00:42 GMT | 2 |
Very new to excel. Here's scenario. On worksheet 1, cell A1 enter 1. Would like this to cross reference this number within a range of number on worksheet 2 and report back the data immediately to right back to cell A2. This down below is how I've entered my data down
|
| Help with saving a filename in VBA | 19 Feb 2008 23:15 GMT | 5 |
If i want to write a macro to save a file as filename x.csv where x is the value contained in cell b2, I tried ActiveWorkbook.SaveAs Filename:= _ "filename "& $b$2 &".csv", FileFormat:=xlCSV,
|
| adding time | 19 Feb 2008 23:06 GMT | 1 |
I am trying to add a series of hours worked and I can't get it to total in hours/minutes. For example: 56:35+6:26+13:00+:38. Any suggestions?
|
| Append multiple files | 19 Feb 2008 21:11 GMT | 2 |
I have the same demographic information in separate files from 10 different states. I need to create a super list append the file content into one file so I can create a mail list. How do I append 10 different excel files with demographic information into one list? I am using ...
|
| How to enter date as text | 19 Feb 2008 20:16 GMT | 6 |
[Newbie question.] I maintain a list of new members of a club in an Excel 2003 spreadsheet I got from a past membership officer. The list, which was started in 2007 simply used the name of the month in Column A. However, when I wrote
|
| Logical formulas | 19 Feb 2008 18:44 GMT | 4 |
I think I got this in the wrong Discussion group. I put it General Discussion before but I think it belongs here. Original Message below: I must admit. I am horrible at logical functions. I am trying to compose a formula that will return a value of "1" if number is greater ...
|
| HOW TO ADD 7% TO LIST OF PRICES | 19 Feb 2008 18:42 GMT | 1 |
I AM TRYING TO FIND OUT HOW TO ADD 7% TO A LIST OF PRICES, IS THERE AN EASY FORMULA?
|
| Excel Printing Error | 19 Feb 2008 17:39 GMT | 4 |
I am working in an excel spreadsheet that was not created by me. The sheet is about 26 rows wide and 250 rows long. I am trying to print and the printer prints a couple of rows, but not all the way over to the right end, and then gives me the following: ERROR: rangecheck ...
|
| format of go to cells - excel 2007 | 19 Feb 2008 16:24 GMT | 2 |
using excel 2007, using find-go to special formulas, the shading on the formula cells is the lightest blue and very difficult to see. Can I change this fill color format? charlie
|
| What is correct formula? | 19 Feb 2008 15:31 GMT | 4 |
Can someone please explain me what is correct formula i excel.....I need to markup or increase A1 for 30% A1=16101.35 =A1*1.3 and that is 20931.75 (B1)
|
| VLOOKUP | 19 Feb 2008 12:30 GMT | 4 |
Using Excel 2002; using a formula; =VLOOKUP($K$2,Sheet1!$A:$G,2) on cell K3 irrespective of what value I input into K2, I get a result in cell K3 regardless of whether K2 is valid or not
|
| formula for removing duplicates. | 19 Feb 2008 11:25 GMT | 1 |
how can I retrieve distinct rows? I need formula not through menu("remove duplicates").
|
| how do i count the freqency of values between certain ranges? | 19 Feb 2008 11:14 GMT | 2 |
i have a set of 10 bin ranges i need to calculate the frequnecy that a set of numbers occur, i tried using the freqency function but cant get it to work correctly
|