| Thread | Last Post | Replies |
|
| Auto Filter With Auto Complete Ability | 26 Dec 2007 20:45 GMT | 1 |
Merry Chrismas I have a list From A2:A8 - Sunday,Monday, Tuesday,Wednesday, Thursday, Friday, Sunday I create a Col Head on A1 and Use AutoFileter, so everytime, when I click
|
| Paste Data To WordPad TXT File | 26 Dec 2007 20:19 GMT | 1 |
I have a fairly simple macro that copies data from a few sheets and consolidates it (via paste) into one sheet. I know what to copy this consoldiates data in this sheet (say A1:G65) and I want to copy it and paste it into a wordpad document file (NewData.txt) and save the txt ...
|
| Building pivot tables in Excel 2007 based on existing pivot tables? | 26 Dec 2007 20:05 GMT | 4 |
So I just installed Excel 2007, and other than the initial shock of interface change, its seems pretty good. I like that the prior Office keyboard shortcuts still work. I've been going though some of the Excel features/commands I commonly
|
| Command Button - Macro to print to pdf, then send pdf to email. | 26 Dec 2007 19:36 GMT | 1 |
I have a command button in my Excel spreadsheet where it will look at the email address typed into a specific field and email the excel file to that email address. What I want to do is when I push the button, First have the page print to a
|
| Sample Size and Confidence Interval | 26 Dec 2007 19:30 GMT | 2 |
Situation: The Hospital Administrator came to me recently and asked "how many patients out of a group of sixty did he need to contact to ensure enough were notified of a possible discrepancy in their medical records(?)". Since this was non-numeric data, and most models are built ...
|
| Combine month day and year from separate columns in to one cell | 26 Dec 2007 19:22 GMT | 3 |
I have the month (October), day (3), and year (2005) contained in three cells. I want to combine them into one cell where I can have the date as 10/3/2005. I have been unsuccessful using concatenate because I cannot change the format of the finished project from 10/3/2005 to ...
|
| Conditional Formating | 26 Dec 2007 18:58 GMT | 3 |
Excell 2003. If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns red or the background cell color changes to grey... Conditional formation is great but when there is a loto of columns I get
|
| How can I vary the row number or column alphabet depending on my n | 26 Dec 2007 18:46 GMT | 7 |
Example- Varying row number. If I need to look up cell A(x) where, A is the column alphabet. x is the variable row number.
|
| IF OR Formula Help | 26 Dec 2007 18:43 GMT | 1 |
I'm having trouble getting this formula to work, what am I doing wrong? =IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&b11&"-"&c11,'Writing Charges (2)'!f3:g237),2,0)*I11)
|
| How do I convert existing excel numbers to negative? | 26 Dec 2007 17:53 GMT | 1 |
I have large amounts of excel data that i need to convert from positive to negative. Is there a way to accomplish this? Thanks.
|
| Chart Wizard Options | 26 Dec 2007 17:42 GMT | 2 |
When creating a chart in Excel 2003 I am offered the option of either a “new sheet” or as an “object in”. How can I lean about the pros and cons of these choices and what each does?
|
| IF and Then in Excel | 26 Dec 2007 17:26 GMT | 1 |
I am trying to compare two different cells in two different worksheets. If the value in A1 in sheet1 is in any of the cells in in sheet2, then value in B1 in sheet1 should be equal to value in C1 in sheet2.
|
| Referring to first cell in a range | 26 Dec 2007 17:14 GMT | 5 |
Hi Friends! I am trying to write down my very first custom function code. The function already requires the user to insert a range. Now, I also need to use the very first cell of the range inserted so.
|
| polynomial growth trends | 26 Dec 2007 17:12 GMT | 3 |
Does anyone know how to project polynomial growth trends in excel - ie a growth rate that initially accelerates and then tapers off after a period - to trend towards an absolute population size (no further growth) after a further period.
|
| how to use if and then in excel | 26 Dec 2007 17:04 GMT | 4 |
I want to confirm that if a2 in sheet 1 is equal to b2 in sheet2 then a3 in sheet1 should be equal to b3 in sheet2. I am trying to use the if and then conditions for the same but i believe i dont know the right syntax to get there.
|