| Thread | Last Post | Replies |
|
| Formatting $19 million | 15 Nov 2007 16:45 GMT | 4 |
I accidentally posted this in the Access Database forum. But needed an excel solution for the following:
>I have several columns with currency amounts from in the hundred thousands >to |
| Help with multiple If statement | 15 Nov 2007 16:33 GMT | 3 |
In cell B4 I have a validation dropdown list of 4 titles. Title 1, 2, 3, 4. In cell G-4 I would like a dollar amount to be placed in that cell in reference to what is selected in B4. When I place =if(B4"Title1"="$110") I can select Title 1 and have that correct dollar amount ...
|
| How can I convert tab delimited files to pipe delimited? | 15 Nov 2007 16:29 GMT | 2 |
I currently have some .txt files which are tab delimited, and I need to convert them so that they are pipe(|) delimited. Any ideas how to do this? Excel seems to support comma, tab and space delimiting, not sure how to use pipe or tilda.
|
| Question on how to raise a price 15% in a coloum | 15 Nov 2007 16:29 GMT | 11 |
I need help on rasisng pricing in a coloum ,(all pricing) I cant figure out how to do it , I can do it in another colom , but I want to do it in the coloum that its in .' any help
|
| Games | 15 Nov 2007 16:29 GMT | 1 |
I have been told about a racing game which is accessible within Excel. How do I access this and are there any other games which are available within the program? Thanks
|
| what is the formula | 15 Nov 2007 16:19 GMT | 4 |
I have a SPR of payments received into our bank account in column c and in column E I have the initials of the person who will earn commision on that payment. What I want to do is obtain the total sum of payments received for that person.
|
| copy down with variable number of rows | 15 Nov 2007 16:18 GMT | 5 |
I would like to add a copy down function into a macro but the number of rows varies. I insert 3 columns A to C and add formulas in the first 3 cells (A1:C1). These formulas need to be copied down as long as there are
|
| How do you identify the first row as headers in EXCEL 2007? | 15 Nov 2007 16:11 GMT | 7 |
I am trying to identify my first row as headers in Excel 2007. What used to be so easy is truly a mystery now. Can anyone please tell me where I do this?
|
| Edit multpile hyperlinks | 15 Nov 2007 16:06 GMT | 2 |
How do you edit multiple hyperlinks at the same time? I have a massive spreadsheet where a tab name has been changed and I need to correct all associated links to that tab.
|
| Cell Markups | 15 Nov 2007 15:54 GMT | 3 |
I would like to know if it is possible to apply a 'blanket' markup on existing cell definitions across an entire spreadsheet. I already have the figures, how do I add 15% to them all? Is there a simple way to do this or do I have to apply a calculation to each cell?
|
| Name an Entire Workbook | 15 Nov 2007 15:49 GMT | 3 |
I need to Merge an Entire Workbook in Excel into a Word Document. How do I name the Entire Workbook to include all worksheets and cells in each worksheet?
|
| Pivot | 15 Nov 2007 15:35 GMT | 2 |
I have the following Pivot Table: Shipper KGS Alfa 1050 Bravo 2010
|
| Check if a folder has x files in it. | 15 Nov 2007 15:35 GMT | 8 |
I am trying to do the following. I have a folder e.g. C:\Folder1 I have this path defined as folderPath1. I want to run a macro that will check that Folder1 has 24 files in it. If
|
| E-Mail Issue in Excel | 15 Nov 2007 15:30 GMT | 4 |
An Excel spreadsheet was sent to me by a superior in my office. There are E-Mail addresses in one column. There are multiple columns that when you try to click on and/or enter data into, a new mail message opens up in Outlook to one of those email addresses. I can not figure ...
|
| Formula to sum multiple columns on multiple criteria | 15 Nov 2007 15:30 GMT | 2 |
I have split up my data in the following manner: A B C D E 8 8 4:30 8 9 8:10 0:00 3:25
|