| Thread | Last Post | Replies |
|
| DSUM function | 22 Apr 2008 17:42 GMT | 13 |
Does anyone know anything about this function? I have been everywhere. I can not get it to work. I have tried every formula I can figure out. I even went to the library for the Excel 2003 for Dummies book and they dont even talk about this function. This is part of my ...
|
| Help me to generate a report | 22 Apr 2008 17:35 GMT | 3 |
I need some help on producing this report - The data: Users Clients Run ID Solutions Update Solutions Brenda Walmart 1234 aaaa System Generated
|
| Simple Find and Replace Question | 22 Apr 2008 17:21 GMT | 9 |
Hello, folks! I'm trying to find and replace a word with another in a column containing text. I'm using Ctrl-H, Find = reciept (for example), Replace with = receipt. This locates a cell containing the word, but when I press Replace,
|
| How to add cells but keep 2 lowest out of solution | 22 Apr 2008 16:19 GMT | 3 |
I need help with adding up a column of values in 'X' amount of cells, but I don't want to include the lowest cells in the addition. For example, I want to add cells A1:A5. But I want the answer to eliminate the two lowest cells out of the equation.
|
| Combine different worksheets | 22 Apr 2008 15:59 GMT | 3 |
Hi, I am working with Excel 2003. I have separate worksheets in different workbooks, each sheet has various rows (from 80 to 800) and all sheets only use 3 columns.I only use one sheet in each workbook. I want to make a summary sheet every 4 weeks which will have all the
|
| Drop List help | 22 Apr 2008 15:56 GMT | 5 |
Is it possible to create a drop list of all the states that allows you to pick which state you want to enter? I will be using it with the wage entry page I have been working on just to enter in the state that I will be working in
|
| Filter every nth record within a worksheet... | 22 Apr 2008 14:26 GMT | 4 |
In the past, I have used the Data/Filter/Advance Filter tool to get unique records based on text in a column. Is there a simple way to obtain the nth rows in a worksheet? For example, I wish to display the 4th, 8th, 12th, 16th, etc. rows. Or perhaps the 3rd, 6th, 9th, 12th,
|
| How to name a sheet from text in a cell in another sheet ? | 22 Apr 2008 14:26 GMT | 17 |
I am very much a novice with using Excel, I'd prefer to be doing this in Access as that's what the data's aimed at in the long run, but the db I'm being forced to use is not mine and I can't work that out either - also work don't support Access so I can't use that to do the
|
| To enable Redo edit button from vc++ | 22 Apr 2008 14:16 GMT | - |
I am using excel as my front end and vc++ as my back end. I enabled undo edit button in tool bar and also in edit menu using OnUndo() function. But now i want to enable the redo button in tool bar and also in edit menu. i found OnRepeat() to repeat the user last action.
|
| q; dividing a sheet into xls files | 22 Apr 2008 14:01 GMT | 2 |
I have an excel sheet, the data is sorted by A column and A column holds three values, Patient, Caller, Doctor and that are other columns that keeps different data. How can I build a macro that exports this whole sheet in to three different files based on the values in A column. ...
|
| How to add amount to a cell based on category and month | 22 Apr 2008 13:15 GMT | 7 |
I have a list of expenxe categories and by month along the top. How can I write the sumif function based on two criteria from drop-down list(one list is Expenses and the second list is the Months) and the third (Amount) cell would be where I input an amount to be added into the ...
|
| sort not working properly ? | 22 Apr 2008 13:02 GMT | 5 |
Is there a way to get the list below to sort in time sequence? Notice that the morning times are after the PM times on Friday. You are looking at 3 columns here. date, hyphen and time. Time column is formatted as time. Sort is in ascending order,
|
| help group rows after exporting report to Excel! :( | 22 Apr 2008 10:29 GMT | 2 |
I have the following issue: After exporting Crystal report file in Excel, I can't group the rows in the exported file. I mean, when I open an exported in Excel report, I can press the
|
| Hyperlinks Broken after saving. | 22 Apr 2008 05:15 GMT | 6 |
We have an Excel 2003 spreadsheet with one column that has a series of hyperlinks to a network drive that is on a different server than the one the spreadsheet is on. After creating the hyperlinks. we are able to use them and all is well. As soon as we save the document the links ...
|
| Find Function not seeking to target | 22 Apr 2008 03:50 GMT | - |
MS Office Excel 2003 (11.5612.5606) ---- I've been using Excel more-or-less as a popular music database. Currently, this sheet contains 25,591 rows of data. I'd routinely
|