| Thread | Last Post | Replies |
|
| How do I get my Quattro Pro 10 files to open with Office Excel? | 07 Sep 2006 03:55 GMT | 1 |
My .qpw files will not open in Office Excel 2003; file format is not valid. I did find a fix for Quattro Pro 7 to Excel 2000, but did not try that for obvious reasons. Also, is the best way to move spreadsheet files from one computer to another via cd? Thank you all in advance.
|
| cell in row has highest value and rtrns col hdr | 07 Sep 2006 03:00 GMT | 11 |
can anyone advise as to which formula would be able to find the highest ("=MAX(A$:T$)")value in a row of cells and once identified return the column header? thanks for any help!
|
| calculate taxes | 07 Sep 2006 01:58 GMT | 4 |
I have columns of sale items that need to have two taxes 7% & 6% added to them. I can do one by but not sure how to combine them. ie 100+7+6=113. What is the formula for this. I am relatively new to this.
|
| In Excel formula to calculate the date someone will hit 65 | 07 Sep 2006 01:56 GMT | 3 |
Using a formula, calculate from birthdate what date a person will turn 65.
|
| How to mix up digits into a new number? | 07 Sep 2006 01:27 GMT | 3 |
I can put single digits into separate columns and concatenate them into one number. Is there a worksheet function or formula that will randomly mix up those same digits into a different concatenated numbers? EX: turning "123" into "231"?
|
| Formula reference to a cell instead of inputing | 06 Sep 2006 23:49 GMT | 2 |
I need the following formula to point to cell (I.e. A3) for the name (John Doe) instead of me putting the name itself. Any advice?
|
| Rename Columns | 06 Sep 2006 23:31 GMT | 6 |
Hi I need to know how to rename a column from the default A,B,C etc to specific names
|
| Amazing 40% rule | 06 Sep 2006 22:53 GMT | 8 |
I have recently come across a statement called " The Amazing 40% rule" in excel, tried to search in google, but got no information on this yet... Can anyone help me to understand this? May be a link to the site where its explained in detail?
|
| Need a macro | 06 Sep 2006 22:12 GMT | 7 |
Ihave data in col A & B Theamount of data can be only 10 lines or could be 100 lines lets assume I have 99 entries in col A & B I would like the macro to copy lines 33 to 66 to start at d1 & d1
|
| Preserving lock on cells even when copied and pasted within a sheet | 06 Sep 2006 22:12 GMT | 4 |
(Sorry for repeating this post from another group; I inadvertently neglected adding both groups in my original post in microsoft.public.excel.misc. In any case, I found a couple of minor errors and omissions that I have corrected :-P.)
|
| Is it possible to... | 06 Sep 2006 21:52 GMT | 1 |
export 1 or more macros automaticlly tather manually? Thanks
|
| collect data from the same row in multiple spreadsheets | 06 Sep 2006 21:30 GMT | 2 |
I have 140 employees with a separate workbook for each.The workbooks contains their by-weekly timesheets. Each workbook has 26 sheets (one for each pay period). I need to start a workbook that will contain the total line for each
|
| summing cells based on "like" value and cell color | 06 Sep 2006 20:30 GMT | 7 |
Is there a way to look at a column and if the cell begins with 01,02,03....98 and the cell color is either yellow or pink to sum those just those cells? So what I'd like to do is sum all the cells starting with 01 that the
|
| Unique text count with multiple criteria? | 06 Sep 2006 20:01 GMT | 4 |
This formula is working but what it's doing right now is giving me a total unique count of names PER QUEUE. Sometimes agents work in two or more queues per day, so what I need it to do is give me a total unique number of names even if the same name shows up under multiple queues.
|
| determine if date range falls within date | 06 Sep 2006 19:35 GMT | 1 |
Ok, this one is driving me crazy! Seems like it should be simple, but no luck so far. Here is what I've got: a2 start date 2/10/06
|