| Thread | Last Post | Replies |
|
| Two People Using Same File | 24 Mar 2006 21:24 GMT | 1 |
It it possible for two people to use and update/save the same file located on a network at the same time? Thanks, CRW
|
| Exceptions to =Countblank function | 24 Mar 2006 21:22 GMT | 3 |
Hello..I am creating a worksheet for the work schedule for X number of employees. I have the worksheet arranged so that if someone has a day off a value of "o" is inserted into a calender type schedule. I then use a =countblank function to add up the blank spaces (which indicate
|
| copying sheet references that refer to a cell in the preceding she | 24 Mar 2006 20:51 GMT | 1 |
I need a cell reference to another sheet to move as I create succeeding sheets. E.g. I name a sheet 03-22-06. The next day, I copy this sheet to create 03-23-06 and on this sheet I reference cell A1 on the 03-22-06 sheet (i.e. =+'03-22-06'!A1). Now, on 3/24, I create sheet ...
|
| Auto fill dates | 24 Mar 2006 20:45 GMT | 1 |
I have a time sheet with a 'date' column for entry from a1 - a7. Once the first date in a1 is entered (mm-dd-yy) is there a way to have the remaining cells auto fill the sequence of dates?
|
| copying with a Macro | 24 Mar 2006 20:45 GMT | 2 |
I need some help! I have a workbook which has four sheets, the two that matter are named work in progress and receipt. My problem is that I need to copy the name, address, city, state, and zip code from the in progress sheet to the receipt sheet, one at a time and place them in ...
|
| Matching Text | 24 Mar 2006 20:45 GMT | 5 |
it seems like a simple problem, but I can't find an answer anywhere. Worksheet One Column A Column B Apples Little Apples
|
| Display Rows From Sheet1 In Sheet2 (Import) | 24 Mar 2006 20:40 GMT | 1 |
I have Sheet1 and Sheet2. I want, in a specific starting cell, to show the rows/columns from Sheet1 that match a single condition (whether or not a month/year of a date matches a specified date). Is this possible? Thanks, Mythran
|
| Conditional Formatting Help. | 24 Mar 2006 20:29 GMT | 1 |
Can anyone help. I have a database with about 6000 entries in it. What im trying to do is to be able to put new records in and then if any get duplicated on 2 seperate columns it would bring it to my attention.
|
| Excel sum, conditional, if?? | 24 Mar 2006 20:21 GMT | 3 |
I have columns A and B. I want A5 to display SUM(A1:A4), only if SUM(B1, B3) is 0 or 1 else the value in A5 should be zero. Is there a formula for doing this? Would appreciate any help. Thanks
|
| special case of sumif | 24 Mar 2006 19:41 GMT | 4 |
I am trying to do a sum but based on a substring instead of the entire contents of a cell. example, A1:A4={"monday, tuesday", "wednesday"," thursday","friday"} and B1:B4={2,4,1,5}. the values in column A may have 2 days in a single string and I want to add based on any one. ...
|
| special case of sumproduct | 24 Mar 2006 19:18 GMT | 2 |
I need some kind of escape character in the criteria part of this function. example, =SUMPRODUCT((A4:A15=("January"))*(B4:B15="Monday")) should also count cells in B4:B15 where the cell contains both Monday and tuesday. something like =SUMPRODUCT((A4:A15=("January"))*(B4 ...
|
| russian excel vlookup | 24 Mar 2006 19:16 GMT | 1 |
Hi - I am trying to teach a colleague over the phone how to use the vlookup function but he can't find it in the Russian version of excel he's using - any one know what vlookup is called in russian language excel? thanks if you can help!
|
| Is there a way to create a toolbar icon for 'page setup'? | 24 Mar 2006 19:15 GMT | 2 |
Long ago I created an icon on my tool bar for 'Page Setup', so I wouldn't need to go File>Page setup, it is now gone. Could someone tell me how to do this - I have forgotten.
|
| Excel Math problem | 24 Mar 2006 19:08 GMT | 1 |
I have an excel spread sheet I'm using. I have found a math error in it on one cell so far. If any one knows where I can send it to. That would be great. It has never been fixed or found since it is also showing up in the newer verions of excel. I have even let our enginners ...
|
| Number to be like in colum A, if number in colum B and C are like | 24 Mar 2006 19:05 GMT | 1 |
How can i get the number of column A to show if column B and C are like in diferent rows? A B C D 1 33221 4131 4000 (value of A3)
|