| Thread | Last Post | Replies |
|
| Finding MIN value in a column between Two Dates in different columns | 28 Oct 2007 04:14 GMT | 3 |
Hope everybody is doing well. I am trying to find a solution to the problem I am having for some time. I seem to have found half of the solution from one of the threads and stuck finding the other half. Here is what I have:
|
| printing without zeros showing in a cell with formulas | 28 Oct 2007 02:05 GMT | 3 |
I've created a workbook that totals 5 worksheets (for Monday thru Friday) on a 6th worksheet that is printed and posted weekly. However, because there is a formula in each cell on the weekly sheet, a zero appears in all of the cells which makes the sheet being posted look too too ...
|
| Time format 1/1/1900 15:20:00 | 28 Oct 2007 00:13 GMT | 1 |
I had some imported times in Access, some of theam are fine, but some of them are like : 1/1/1900 15:20:00 , after copying them to excel they have remained the same, and after apply number formats they are the same, I did see a previous posting where you copy a value of 60 paste ...
|
| match 1 column bringing in a value from another column | 27 Oct 2007 22:34 GMT | 3 |
I tried using vlookup to lookup information in 1 column then go to another worksheet and bring in the information for another column. Below is the formula I'm using but I either get #N/A or the wrong information. What I have is a list of outstanding payments I'm trying to match ...
|
| Excel Function | 27 Oct 2007 21:15 GMT | 5 |
Is there a function in Excel where you can select a column of figures, then ask what figures in the column add up to a certain amount? Example - you have a check for $24,674.82 and a long list of amounts. The check may be for 20 or 30 amounts totaled together in the column. ...
|
| Cannot Exceed | 27 Oct 2007 20:43 GMT | 8 |
I am working on a formula based on 5% growth per month. I started out with 100 units in January and in February that number will be 105, and so on. I have a maximum number of 150 units I cannot exceed for a formula. Is there anyway to set this up as a growth rate per month and ...
|
| Check off Box?? | 27 Oct 2007 19:41 GMT | 3 |
Can I add a "check off box" into a document. I am trying to add a box that I can click and as I go through a document. As I "click or check-off" a box, the column will add those rows that have been checked. I know how to use the "IF" function, but I want the user to just be able ...
|
| Group data from a table | 27 Oct 2007 16:04 GMT | 1 |
in the worksheet 'Stock' have a table with many columns , and in one column the input list has always 4 names of people. (Haris, Chris, Tom, Michael) Now i want to have 4 different worksheet, one for each person. How can i gather the data of each speicific person and transfer it ...
|
| Consolidate information from Column B Based on Info In Column A | 27 Oct 2007 16:02 GMT | 1 |
Suppose I have Column A that contains a company's name and in Column B is a stockholder in that company. However, the program that provides this information only puts one shareholder in each cell in column B. For example: Microsoft Bob Jones
|
| Help on substitue value, by excel function | 27 Oct 2007 15:42 GMT | 2 |
i receive BIG data files with customer name, location, bill number, date and due amount, reason for delay in payment etc., But customer is spelled in many ways and sent to me. However some portion will be unique.
|
| Protected sheet, On Enter moves next. Can I stop this? | 27 Oct 2007 15:29 GMT | 3 |
I have a protected Excel Worksheet. Only specific cells are unlocked for data entry. The behavior for protected sheets on enter is to move to the next unlocked cell. Is there any way to make the move next not happen? (I have that box unchecked in Tools|Options.)
|
| Conditional auto printing in excell? | 27 Oct 2007 15:18 GMT | 1 |
How do I write macro for conditional auto printing in excell? I have tried things like: if L2>0 then print. This would be that a number greater than 0 would get the system to print the page. This is to be encorporated into an existing macro
|
| lookup with multiple condition, but one condition to satisfy is en | 27 Oct 2007 14:06 GMT | 2 |
I am looking to compare 2 sheets with 20 columns but i need to compare sheet 1 having 75 rows & sheet 2 having 2000 rows sheet1 column d d2:d75 to compare in sheet2 column b b2:b2000 sheet1 column e e2:e75 to compare in sheet2 column b c2:c2000
|
| Counting Within a Date Range | 27 Oct 2007 13:59 GMT | 2 |
I'm trying to count the number of people present during any given date range which I have been able to do. The problem I'm having is including people who are still here. My simplified dataset looks like this A B C
|
| Excel Formular help | 27 Oct 2007 12:35 GMT | 1 |
I am trying to reference dates within a spreadshett that fall per fanancial year and return it as a number representing the quarter of the year for which it falls. For eample if I have a date in column A
|