| Thread | Last Post | Replies |
|
| How to format a cell to make it blank if it's content is "N/A" | 08 Mar 2007 14:19 GMT | 7 |
How to format a cell to make it blank if it's content is "N/A" Thanks Turk
|
| How do I put combo box values into cells (without using @CHOOSE) | 08 Mar 2007 13:44 GMT | 4 |
I am using a combo box to select from a very long list. In order to save repeating the process of selecting from the combo box on each sheet in the workbook I would like to transfer the value displaid in the first combo into a cell on each of the other sheets. The list is too ...
|
| If sate ment using edate | 08 Mar 2007 13:04 GMT | 4 |
to keep my cell clear until someone enters data in another cell I would like to do the following formula =IF($G15="", "",edate($G15.1)) This is not working
|
| Worksheet Security/Cell Protection | 08 Mar 2007 10:47 GMT | 2 |
Is there a way to have 2 sets of cell protection passwords - one that protects specific cells for one group of users and a different password that protects a different set of cells for another group of users - in the same worksheet?
|
| Format Cells to calculate hours and minutes taken to complete task | 08 Mar 2007 10:45 GMT | 5 |
I have the following calculation in my column E: =((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24 Column D is Date/Time order completed in format: dd/mm/yyyy hh:mm:ss Column C is Date/Time order received in format: dd/mm/yyyy hh:mm:ss
|
| HyperLink | 08 Mar 2007 10:26 GMT | 1 |
Good Day My name is LLoyd I have a list in one sheet, on the other I have Validation in a cell which comes from a list, then below that =VLOOKUP($C$2,Database,5,0) in cells, but my last Vlookup pick up a hyperlink, but it see it as text not a hyperlink.
|
| SQL syntax | 08 Mar 2007 08:27 GMT | 2 |
I will be very grateful for the SQL syntax to use for an ADO query on a large csv to pull in all the rows of data for one specific fund to an Excel spreadsheet. There are about 35 funds listed in the first column headed "Funds".
|
| Split up summary sheet | 08 Mar 2007 07:08 GMT | 2 |
I have created a monthly time sheet for my employees to fill out. Since they can work on different projects during the days of the month, the spreadsheet looks like this: M A R C
|
| one variable data table | 08 Mar 2007 06:57 GMT | 2 |
heres a question from my text book that i dont understand what to do example: the the range D4:G15, create a one-variable data table that calculates the Revenue, Expenses, and Net Income bases on the Customers( per day) value....
|
| Countif? | 08 Mar 2007 04:59 GMT | 4 |
(please forgive me if this is a duplicate posting...) I'm trying to do the following: Count how many cells (rows) in column A that has the value 1 in Column C AND value 1 in Column D?
|
| copy equations between spreadsheets | 08 Mar 2007 04:57 GMT | 2 |
This should be simple... I have equations in one spreadsheet that reference cells in other worksheets within that spreadsheet. I'm looking to copy these equations to another spreadsheet and retain the relative reference to the named worksheet (i.e.
|
| How to use the CountSum funtion of worksheet in Macros | 08 Mar 2007 03:59 GMT | 1 |
I need to count the sumn of values present in a column or row using Excel macros.
|
| Solver for excel | 08 Mar 2007 03:48 GMT | 1 |
how do i add the Solver for excel without the disc?
|
| attach files | 08 Mar 2007 03:42 GMT | 1 |
I would like to set up a spread sheet where I can track income and expenses and at the same time attach a pdf file of the corresponding invoice. Is this possible in excel?
|
| wnat to extract first & last names in sep cols from name list in 1 | 08 Mar 2007 03:27 GMT | 4 |
I have a list of names that shows first and last names in one column (entry ="John Doe") I want to separate these into two columns so that I have one column with entry="John" and next column has entry="Doe". I can do this the loooong way bt copying the first column over twice, ...
|