| Thread | Last Post | Replies |
|
| Excel Functions: Countif Problems | 26 Jan 2004 21:27 GMT | 3 |
75.00% 33.33% 41.67% A B C 37.65 50.00 37.64 33.48 39.74 46.95
|
| Sorting of mixed zip codes (5 digit and 9 digit) in ascending order | 26 Jan 2004 21:08 GMT | 3 |
I have a large mailing list in FileMaker Pro which I export to Excel so that a printing house can take the Excel address mailing list, with the addresses sorted in ascending zip code order, to do a mail merge with the Word document (brochure). Essentially, they print the ...
|
| Referencing the cell that is calling a function. | 26 Jan 2004 21:02 GMT | 5 |
Is there a function, or constant string that references the cell that is calling the function, without putting an explicit R1C1 reference as an argument? For example, let's say I wanted to use the offset function
|
| I figured out how to protect individual cells! | 26 Jan 2004 20:46 GMT | 1 |
Thanks if you were working on a reply.
|
| Change label column | 26 Jan 2004 20:32 GMT | 2 |
Hello... usually we use the numbers for files and letters for column.....example a:1 how can I change the column to use numbers for columns and
|
| Linking in Excel | 26 Jan 2004 20:05 GMT | 2 |
I have a Worksheet that shows a link to three other worksheets. I have searched the entire document for this link and it is not in there. How can I break the link. I need to send this document to a third party and do not
|
| Formula and text within same cell | 26 Jan 2004 20:01 GMT | 8 |
Is there a way to have a formula and text within the same cell? This is what I want to do: Date: =TODAY() Is there a way I can get the formula to work with the text "Date:" in
|
| If function with date ranges | 26 Jan 2004 20:01 GMT | 3 |
How can I create a IF formula that will state the following If a persons membership dates falls between the following dates, then label him as Tier Tw Prior to 7/01/03 = "Tier One 7/01/73-7/26/76 ="Tier Two
|
| Extracting specific information | 26 Jan 2004 19:48 GMT | 2 |
Here is an actual sample of an exported file that I am dealing with from EasyPay Payroll: Code : Name : Smith, Jacque line Type/F
|
| Automatically update imported data | 26 Jan 2004 19:38 GMT | 3 |
I have 1 excel report that has 18 separate external data sources, this report then is used to create a statistic report. At present all the reports are pasted into the Excel
|
| Can a macro find straight portions of a graph? | 26 Jan 2004 19:26 GMT | 2 |
Hello, I'm not sure if this is possible in excel, but im hoping it is! Ok I have a very large data set of events occurring at different times over a 50 year period. When plotted cumulatively I need to identify the sections of the graph which have a constant gradient(or near
|
| Using Countif across multiple sheets | 26 Jan 2004 19:01 GMT | 29 |
I am attempting to count the number of non-zero cells in a rang spanning multiple sheets. For example, I have the following: On Sheet1: A1 = 5
|
| new user question | 26 Jan 2004 18:54 GMT | 2 |
I am trying to use the following expression: eg: =IF(A3="","", IF(B3="","offline","online")) where A3 is a tool number
|
| Recursively using VLOOKUP | 26 Jan 2004 18:39 GMT | 2 |
Wonder if anyone can help me. The deal is I have two sheets in a boo one called TABLE_ROWS the other called TABLES (they store databas table information). I currently use VLOOKUP to lookup a table name an populat a cell. Using:
|
| anchor an object to a cell | 26 Jan 2004 18:31 GMT | 1 |
I have an object that floats on this spreadsheet. I want to anchor it to a specific cell so that when I resort the spreadsheet the object will go with that specific row. In this casae the object is an embedded equation object.
|